Read Only ????

[MaleNurse325]

Good day everyone,

I have developed a small database for several colleagues to manage simple tasks.

These colleagues work in remote locations and the databases, for each location are housed on a server. 4 out of the 5 databases, which are all copies of a master version work absolutely fine, the fifth however....

One database has decided that it will only grant read only access whilst on the server. once it was copied to the hard drive of the users computer, it works fine.

Any ideas~?

Steve​

 

[pbaldy]

My first thought is to check user permissions on the server folder. They need at least read/write so the lccdb file can be created and written to.

 

[MaleNurse325]

no they have permission they can access any folders or files in that location.

 

[The_Doc_Man]

Specifically, saying they can access any file/folder doesn't quite match up. Let me try to be explicit. In order to use an Access database from a server, the user in question must have the permissions consistent with the Windows "Modify" permission profile. (Remember that you don't see ALL of the permissions at the low level unless you go to the Advanced option.) Just having read/write is not enough. You also need Create and Delete because of the things you will need to do to the lock file. Using general Windows profile "Write" is not enough.