database engine could not lock

[dwhawley]

i'm working on an access database program in which i create two with a make-table query and then delete them after they have served their purpose. however, after i create them, microsoft jet will not let me delete them saying that they are in use by another person or process. i would think that the only process interfering would be the same one that created the tables. if this is the case, how do close the make-table query and if it's not, what else could be the problem?

[DrewDog_21]

Coincidentally, dwhawley, I had a similar problem just yesterday I am using DAO with Jet 4.0 and Access 2000, and my program performs a similar operation (creates one temporary table then deletes it when finished).

I receive the message whenever I have the database open with MSAccess. One would think that it would only be a problem if I had the specific table open, but that seems not to be the case. Make sure that you have the entire database closed, because you might very well be having the same problem.


------------------
Andrew Nerney
Hapless Programmer
[email protected]

[dwhawley]

thanks for your reply, drewdog. the program that i am writing would require that these tables be created and deleted several times during one session. in your opinion, would it be easier to map the information to these tables and then use a DELETE statement to clear them or would you continue to use the make-table query and then delete the tables afterwards?