Martyh
Registered User.
- Local time
- Today, 01:08
- Joined
- May 2, 2000
- Messages
- 196

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!