Database locking up

[Corsica]

When I run VB modules, from the editor or during the execution of an event procedure, I sometimes get a message saying (something similar to....):

The database is locked as it is currently in use by another user...

Each time this message has appeared on screen, I have been the only user.

-Reseting the module and saving it often doesn't 'sort things out'. In many instances I have had to close the database file. When this hasn't 'unlocked' the database, I have had to restart the computer.

However, getting things started again isn't the only problem, as I would also simply like to not have my work flow halted on a regular basis by the need to 'free up' the database!

Any ideas....Your feedback, suggestions etc. would be much appreciated.

Thanks
CSC

 

[hymn]

Tools
Options
Advanced
Check your locking status
If you dont understand read up on it or try doing a search on Record locking

Hope this helps
Hymn

 

[Corsica]

Thanks for your reply Hymn. I don't think that I worded my question as well as I could have:

When a VB module is run, from the editor or via an event procedure, I sometimes get the following error message:

"The database has been placed in a state by an unknown user that prevents it from being opened or locked."

-I've found that to unlock the databse I must then close the database file.

I have had this error message come up numerous times when I have been working on my home computer, which is not part of a network.

Thanks in advance to anyone who would take the time to reply with any information that he/she thinks might be helpful.

CSC