98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Database locking
Database locking
Resolved · Medium Priority · Version 2003
Fri 29 Jan 2010, 11:18Delegate 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:51Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Change caseTo change case from upper or lower case, highlight the text area, hold down the Shift key and pres F3 |
