By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,961 Members | 1,333 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,961 IT Pros & Developers. It's quick & easy.

Error Executing the command or ..could not lock table becouse it is in use by..

P: 19
i have (another) problem. The database i've been trying to design has been going trough a bit of testing. During those tests we've noticed that when trying to access a form from the swich board the "Error Executing the command" occurs (this is happening only when a user has allready accessed the form and others try to do the same). This is strange because the other 2 forms on the swichboard don't have this problem...and their design is bassically the same (except the one with the error one does not have a subform on it witch gets requeried after insert).

If i try entering the form directly i get the "the database engine could not lock table becouse it is in use by another person or program"

has anyone had this problem?

i have no missing reference. no nothing. Iv'se searched on the net and the solutions found did not solve the problem.

Thanks
Oct 5 '09 #1

✓ answered by Kan09

I found the prblem the next morning. The record loks property was at fault for the problem.

Thank you for the help

Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,344
Check the designs of the forms. Specifically the RecordSources. Ensure that the query type (properties of the query) are set to Snapshot.
Oct 5 '09 #2

P: 19
I found the prblem the next morning. The record loks property was at fault for the problem.

Thank you for the help
Oct 7 '09 #3

NeoPa
Expert Mod 15k+
P: 31,344
No worries. Thanks for posting the update.

Welcome to Bytes!
Oct 7 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.