Cannot Lock Table Access 2003

[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.

 

[Gina Whipp]

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