Mind Block -- Locking tables

Martyh

Registered User.
Local time
Today, 00:04
Joined
May 2, 2000
Messages
196
:confused: I've hit a "mind block" --- part of me says that it can be done and part of me struggles with reality !

I've hit the error --

"Runtime error 3211 -- The database engine could not lock the table 'tblLevels' because it is already in use by another user or process."

A few things --
1) I'm using access 2000 - client's choice ( I used to use this 5 yrs ago)

2) the error is happening when go from a form to a report -- the form sets up the parameters

3) I've ruled out the other user because I'm the only one using the database!

4) the table "tblLevel" is used in several combo boxes (leading to the output of a report based on the Level)

5) the instant that I do the docmd.openreport -- the error occurs

6) there are other table( for instance tblGLAccounts) which perform as expected ie I choose the GL number from a combo box and the report opens correctly

Any help would be appreciated!
 

Users who are viewing this thread

Back
Top Bottom