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

[Kan09]

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

[NeoPa]

Check the designs of the forms. Specifically the RecordSources. Ensure that the query type (properties of the query) are set to Snapshot.

[Kan09]

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

Thank you for the help

[NeoPa]

No worries. Thanks for posting the update.

Welcome to Bytes!