H
Heinz-Oz
In Access 2003, I am developing a database and create a temporary table with
a make table query. Once I am done with the table and have closed all objects
based on that table, Access will not alow me to delete the table with a macro
action "DeleteObject". It tells me that the data base engine could not lock
the table because another user is accessing it. There is no other user and no
object is open which is connected with that table.
I have tried everything I could think of, in vain. When I close the error
mesage and select the table in the database window, I can delete it. I even
tried to select the table in the database window inside the macro and prior
to deleting it. Still no success. What could be causing it?
a make table query. Once I am done with the table and have closed all objects
based on that table, Access will not alow me to delete the table with a macro
action "DeleteObject". It tells me that the data base engine could not lock
the table because another user is accessing it. There is no other user and no
object is open which is connected with that table.
I have tried everything I could think of, in vain. When I close the error
mesage and select the table in the database window, I can delete it. I even
tried to select the table in the database window inside the macro and prior
to deleting it. Still no success. What could be causing it?