Error Message: Microsoft Jet Database Engine

[rajivvyas]

I am trying to make changes to a particular field in Access but whenever I try to do this, I get an error messsage saying that Microsoft Jet Database Engine Stopped the process because you and another user are attempting to change the same data at the same time.

There is no once accessing the database at this time and this error message appears only when I go to that specific field. I've also tried to delete the whole row but it wouldn't allow me to do that saying the program has been locked.

Any solutions? Thanks,

Rajiv

 

[gemma-the-husky]

Have you got the record open locked in your own form, at the same time as you are trying to delete it.

If not, try compact and repair, and restart your machine in case windows has some phantom process running.

 

[rajivvyas]

I don't use Access that much. So, what exactly is "compact" and "repair". I am using Access 2000. Also how do I know if I have got my record locked in my own form, and if it is, how do I fix it?


Thanks,

 

[KeithG]

if you have your form open to the record you are trying to delete you won't be able to delete it. To compact and repair select Tools/Database Utilities/Compact and Repair

 

[rajivvyas]

Compact and Repair worked. Thanks,

Rajiv