Database locking

The UK's most regular instructor-led training courses.
Training information: access.training · Access training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Medium Priority · Version 2003

2 posts

ReplyFri 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.

Version	Date	Location	Places available	Book	Next place rate (£)
Access VBA 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Wed 24 + Thu 25 Mar 2010	Southwark	8		£445	£450
2003	Wed 5 + Thu 6 May 2010	Bloomsbury	10		£275	£280
2003	Mon 28 + Tue 29 Jun 2010	Bloomsbury	10		£275	£280
2003	Wed 4 + Thu 5 Aug 2010	Bloomsbury	10		£275	£280
2003	Thu 9 + Fri 10 Sep 2010	Bloomsbury	10		£275	£280
2003	Wed 27 + Thu 28 Oct 2010	Bloomsbury	10		£275	£280
Full Schedule: See all 7 Access VBA course dates. Bookings currently available until 6th December 2010.

336 posts

ReplyWed 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

· Access Corruption Avoidance Tip #1: Split Your Database
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· Microsoft Access 2007: New Features
· Take an Access Course to Learn About Relational Databases
· So what's new in Access 2007?

Please browse our web site to find out more about
access.training and other Microsoft training courses.

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.