P
Paul Dennis
I have a main form which has a sub form. The sub form displays data from a
table.
One of the options on the main form is to call a macro, which closes the
main form and then runs a query which updates the table the sub form uses.
I get an error saying "the database engine cannot lock table xyz because
it's in use by another user".
I have checked the sub form and the data is set to read only.
Is there a solution to this?
table.
One of the options on the main form is to call a macro, which closes the
main form and then runs a query which updates the table the sub form uses.
I get an error saying "the database engine cannot lock table xyz because
it's in use by another user".
I have checked the sub form and the data is set to read only.
Is there a solution to this?