"The database engine could not lock table" (1 Viewer)

laxster

Registered User.
Local time
Today, 05:17
Joined
Aug 25, 2009
Messages
145
I have a macro that closes a form and updates the table it is based on, then reopens the form. If I run the macro from the side pane it works fine, but when I try running it from a button on the form I get the following message:

The database engine could not lock table ' TblLastUpdateDate ' because it is already in use by another person or process.

It must have something to do with the form, but I cannot decipher it.
 

vbaInet

AWF VIP
Local time
Today, 10:17
Joined
Jan 22, 2010
Messages
26,374
You are running it on the form that is tied to the table that you want to update. And I reckon you have unsaved changes in the form that has a lock on the table.

OR

Someone else is working on the record you are trying to update.
 

Users who are viewing this thread

Top Bottom