The error is The database engine could not lock table 'ProdSum4' because it is already in use by another person or process. I get an action failed on my last query before my report when I use my command button to run my macro. However when I just run the macro, it works fine. Why do I get this error when all I have open is the database window and the form with the command button on it? What do I have to change to get my macro to run from the form?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Error-Locked table
- Thread starter Bufsabres
- Start date
Similar threads
- Locked
- Question
- Locked
- Question