CODEWITHSUNDEEP
databaseconcurrencyms-access-2007vb.net-2010
edgarmtze
edgarmtze

Reputation: 25058

Approach to Edit MS Access database with the same VB.NET 2010 standalone program on different computers

I have an application in VB.NET 2010, and a MS Access database 2007 where I am able to edit (add, delete, update) registries with that standalone program that connects to it using Odbc. The program needs to run in 2 computers, so 2 people would edit the database (maybe at the same time)...

Is it possible that somehow using the same program in both computers they can edit only one MS Access database?

I was thinking on a intranet or something to share the MS Access database file, but Is there a better approach? Is there any example?

Upvotes: 0

Views: 410

Answers (1)

prprcupofcoffee
prprcupofcoffee

Reputation: 2970

To use an Access database from more than one computer, put it on a network share. Access handles the concurrent usage by way of the .ldb file. Only try this on a network that is very reliable, or you will run into database corruption, though.

Upvotes: 1

Related Questions