Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » Database locking
|
|
|
Bookmark this page|
The UK's most regular 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. |
Database locking
Resolved · Medium Priority · Version 2003
Reply
Database locking
I have created an Access Database which has no internalSecurity - 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.
For upcoming training course dates see: Pricing & availability
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
|
 |
|
» Forum post: Desktop shortcut/ quick launch |
Find Out About SmartArt In Microsoft Office 2007/2010 One of the many new visual features available in Office 2007 and 2010 is SmartArt. This is a progression from the Diagram feature found in previous Office versions and offers a vastly improved range of graphical diagrams to choose from, with a wealth of formatting features. The results are truly stunning. This article summarises the key aspects of SmartArt. » Article: Microsoft office training london |
Morning, I have created a shared database and somehow managed to get an icon on my desktop which is the only way I can open my database. I now need to share the database, how can I send a link to them for them to create the icon on their desktops?
