DATABASE LOCKED

[turnerk200]

Hello there, I am currently using DAO to open a recordset in my database which is working fine, however when i go to run the code a second time i get the following error message.

Run-time error '3734'
The database has been placed in a state by user 'Admin'
on machine 'W00497' that prevents it from being opened or locked.

Does this have something to do with DAO? I need to close down access and re-open it to run the code again. Hope somebody can help.
Thanks,
kt

 

[PHV]

In your DAO code are you sure you have closed and released all the objects instantiated ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[turnerk200]

Thanks very much for your response, i had released the d/base object, but not the recordset object, this seems to have done it. Thanks again.

 

[turnerk200]

Take that back - it is still doing it! Any more ideas?