Using Access 2003 I have a front end/back end application which I install on my client's machine. I install BE (.mdb) in a central location and FE (.mde's) on each person's machine.
I have designed many Access Client Server Applications before where I have the 1 MDB file on the Hard Drive & the data MDB file on the server & have the Tables Linked. For this one client when I do the same when 1 user logs in they are fine.
I have a database that requires two separate groups of users -- one will have read-only access, the others will be able to change data. Furthermore, the forms in the front end will display differently depending upon the user group of the person signing in. The shortcut to the ...