Has anyone encountered this error message?

It keeps happening to one of our applications, and basically kills the entire database. This is a database that is used by about 5 different people.

Error message....

The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.



John

I've runned into the same problem yesterday. For some reason it seems that there is a lock happening even if there is no real lock. I "temporarily" fixed it by compacting the database (in the tools menu).

Unfortunately, I do not know how to prevent this problem from happening again.

Others will know more than I, but for now...

For each control onthe form, goto the Data table and Set the Record Locks value.

Something that also might work is splitting the database. You can use the wizard, but I prefer just to make a copy of the database and call one MyDataBase-DB.mdb and MyDataBase-GUI.mdb or whatever you would like. Delete all the Forms, Queries, Reports and Modules from the DB Version, and delete all Tables from the GUI one. Then go into the GUI 1 and link all the tables from the DB one.

Trying both of these should help you out.

Mike

Mike
EchoVue.com