Database locking

Resolved · Medium Priority · Version 2003

Fri 29 Jan 2010, 11:18 Delegate Pat said...

Pat has attended:
Access Advanced course

Database locking

I have created an Access Database which has no internal
Security - Our IT department gave the initial set of users
full read/write access to the folder on the server where the
Database sits , as this set of users required full access. These
users have been using the database with no problems (including when several are using it at the same time) .
Our IT department has now given more people access to the
Folder containing the database , but has given them read only access to the folder, as they will be using the database
to view information only. When any of these users trys to open the database they get the message 'Could not lock file' & cannot open it. Is this because of the 'Read only' folder access that these user have benn given? Is the only way to give mixed full or read only accessto the database by creating user groups etc.

Wed 3 Feb 2010, 06:51 Trainer Anthony said...

RE: Database locking

Hi Pat, thanks for your query. Your problem has been encountered by others and there is a discussion of it here:

http://tinyurl.com/yg7pq7v

It seems some advise making changes to the registry of the individual computers accessing the database which is definitely something you should get IT to do rather than yourself, and I have a feeling they will be reluctant to do so. Usergroups may solve this situation, but a workaround could be a series of separate databases in difficult folders with different permission settings, and a master database which runs an append query on opening.

Alternatively, why not create a switchboard at the start of the database? It could either be a simple password entry, or allow only those with an admin password to run select queries which would be output to a report which would prevent changes being made. Others with the right password could access the whole thing.

Hope this helps,

Anthony

Training courses