table is used by another user 1

[roamer762]

Hello,

I am entering data in a form based on xyz tablewithout any problems. When I close this form and opens it again it tels me that it cannot do so cause the table is used or locked by anotheer user. I am the only person using the db and the table is closed. I have tried to use the deleteobject method and deleting the table and creating it again but still problem persists.The only way as far as I know is by repairing the db.

Can anyone please tell me what am i doing wrong and what can I add to my code/

Cheers

Sally

 

[PHV]

You don't use any recordset in your form that you forgot to close and release ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886