469,592 Members | 1,698 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,592 developers. It's quick & easy.

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

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

3 2174
NeoPa
32,198 Expert Mod 16PB
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
Kan09
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
32,198 Expert Mod 16PB
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.

Similar topics

2 posts views Thread by pargat singh | last post: by
reply views Thread by Morten Gulbrandsen | last post: by
5 posts views Thread by prakashwadhwani | last post: by
15 posts views Thread by Lawrence Krubner | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.