Multi user (1 x rwx, 2 x r--)

[eagle13]

I have read a lot about if multiple users want to share an MDB, they have to create BE and FE and split the database.

I understand having to do that if all those users want to write to the MDB simultaneously.

I have a situation where one person will do data entry (write access), and two other users will just want to view and perhaps just search the database (read).

If only one person is writing at any time, do I have to do all that splitting and FE/BE configuration?

 

[boblarson]

Yep, otherwise you run a greater risk of corruption and performance issues.

 

[DrSnuggles]

Plus, if the database becomes corrupt you may lose data.
Thus splitting the db it is allows you to refresh corrupted front-ends without touching the back-ends.

I created a batch file that downloads the front-end to the users C Drive.
See the batch file and version file attached.

1. Put your db and version file in the same server folder.
2. To start the application Create a Shortcut pointing to the batch file, let the batch file do all the rest.
3. To force a new download, increment the version no. i.e versionfile.0002 on the server and in the batch file. Then batch file will take care of the rest.