Cannot Lock Table Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In the AfterUpdate event on a Combo Box (data from tblName) I have:

DoCmd.OpenQuery "qryName"

The error I get is something like:

"Can not lock on tblName. Someone/another process is using it..."

The query (only table is tblName) is Make Table .

How do I prevent error message from appearing?

Thanks.
 
I think what you are trying to do is Make Table Query while you are
accessing that query via a combo box. No can do, hence your error message.
Maybe you should pose what you are trying to do and see if someone can help
you find another way to do it.

For instance, if you are trying to add a new name perhaps an append query
will do...

HTH,
Gina Whipp
 
Back
Top