Deleting tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
Back
Top