Deleting tables

J

JED

I made two tables with two seperate make-table queries in VBA. I then use
the data to make a recordset. I try to delete the tables to run the
make-table queries again but get an error message saying that Access cannot
lock the tables as another user has them open. I have closed the tables but
still get the same message. The Database is stand-alone. I am running
Windows XP on a 1 GigaHertz, 1GigaByte machine with Access 2003
 
J

John Spencer

Could you show us at least the relevant portions of your code. A BIG OL' GUESS
is that you have a recordset open that is using the tables OR you didn't "clean
up" after yourself and make sure that the recordset has been set to nothing.
 
J

JED

Thanks John,

That was the only thing I hadn't tried and it was the answer. Feel sort of
silly I didn't think of it.

Thanks again

JED
 
Top