The database engine could not lock table (table name) because it

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

Resolved · Urgent Priority · Version 2000

11 posts

ReplyThu 10 Dec 2009, 08:31Delegate Gary said...

Gary has attended:
Access VBA course
Excel VBA Advanced course

The database engine could not lock table (table name) because it

Hello,

I have two table that are joined on a one to one join type, referrential integrity is enforced.

Then I designed a query from my table to provide customers that match a certain criteria in a date range. This has parameter fields that let the person choose the date on which data they need to search.

From that I have then designed a report based on the query, this then displays the query in a more presentable format.

I have then included a command button as a link to the form and when it is pressed the above error appears. But, when I exit the form I can run the report in the Objects pane with no problems. There is something conflicting somewhere, but I have used this technique in the past and it has worked. I need this for a corportate database that I am designing so a response would be appreciated as soon as possible.

Thanks,

Gary

Version	Date	Location	Places available	Book	Next place rate (£)
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Tue 23 Mar 2010	Bloomsbury	3		£224	£225
2003	Tue 30 Mar 2010	Bloomsbury	6		£199	£204
2003	Thu 22 Apr 2010	Southwark	5		£195	£200
2007	Tue 27 Apr 2010	Bloomsbury	4		£224	£225
2003	Fri 28 May 2010	Bloomsbury	9		£110	£115
2003	Wed 16 Jun 2010	Bloomsbury	8		£95	£100
Full Schedule: See all 20 Access Intermediate course dates. Bookings currently available until 17th December 2010.

11 posts

ReplyThu 10 Dec 2009, 08:32Delegate Gary said...

RE: The database engine could not lock table (table name) becaus

The Title should have read as above!

748 posts

ReplyFri 11 Dec 2009, 13:33Trainer Stephen said...

RE: The database engine could not lock table (table name) becaus

Hi Gary

Thanks for your question

Sorry for the slight delay in replying

Unfortunately I cannot see the full error message as you used it in the title to your post. Could you repost it in the body of the post so I can have a look

Thanks

Stephen

· Microsoft Access Courses
· MS Access and Database Normalisation
· Be Top Of The Form With Access 2007
· Access Corruption Avoidance Tip #2: Avoid Dangerous Data
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps

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

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips