Multiple access

[Manesti]

I have an application built in vb.net and uses an access database. I want the application to be on one system while other computer on the network access it too. DoI need to change my connection string and installon all the other systems?please I need to know how to go about it. thanks

 

[jmcilhinney]

All you need to do is change the connection string to refer to the location of the data file relative to the local system.

 

[cjard]

If you want all computers on the network to access the one database then:

on the master computer the connection string references a local path
On all the slave computers the connection string references a NETWORK FILE SHARE with proper permissions


If you manage to go a few months without multi-user locking issues, youre doing well. If youre making your app network aware then you should use SQLServer Xpress, Oracle 10 Express or some other proper, network, multiuser database. Jet will be a pain in your multi-user arse, I promise..