B
Bob
If I know I am the only user of a database, how can I remove the lock so I
can delete a table? I have a Macro that initiates a "make table" query and
the macro fails because it can not delete the existing table first. There
error meesage I receive when I try to manually delete the table is as follows:
You tried to lock table <name> while opening it, but the table cannot be
locked because it is currently in use. Wait a moment, and then try the
operation again. (Error 3009)
The username that is shown on the lock info is my username. I have tried to
delete this table for several days and I am in dire need of help!!
Thanks in advance for your help.
can delete a table? I have a Macro that initiates a "make table" query and
the macro fails because it can not delete the existing table first. There
error meesage I receive when I try to manually delete the table is as follows:
You tried to lock table <name> while opening it, but the table cannot be
locked because it is currently in use. Wait a moment, and then try the
operation again. (Error 3009)
The username that is shown on the lock info is my username. I have tried to
delete this table for several days and I am in dire need of help!!
Thanks in advance for your help.