2 users accessing the same mdb

[Cheung]

I am developing a windows application using vb.net. when the applications are running on two different machines at the same time, they can both enquire the same mdb file. However, only the applications started earlier can insert/update/delete the records in the mdb. What can I do so that the applications can update the mdb at the same time (assume there is no conflict in the updates)?

Thanks!

 

[Dilyias]

Only open a connection when you need it and close it as soon as you are done.. I.e. dont use a global connection object that is always open. I guess it depends on the nature of the app to see if this is acceptable for performance, etc...