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