C # Access LAN shared access

Some of your own experiences.

To remotely access the ACCESS database, you only need to use the network path \ 192.168.1.12 \ xx. mdb, that is, the connection string can be: @ "provider = Microsoft. jet. oledb.4.0; datasource =\\\ 192.168.1.12 \ xx. MDB; persist Security info = false ;"

However, it is not good for multiple users to access the database at the same time, So Microsoft provides a way to split the database into front-end and back-end databases, and put the back-end database in the shared folder of the server, the front-end database can be placed on each client.

There are many ways on the Internet. I am just one of them,

1. Set the shared folder for storing the background database

2. Split the database. This is very important. Pay attention to the storage path! You must use the network neighbor to find the folder in your computer and confirm the splitting. Then, access will store the background database files, usually ending with "be", to the shared folder. The database file opened at the beginning will become the front-end databaseProgramIf necessary, you only need to copy the front-end database file and open it to link to the back-end database!