problem (2k)

Topic

New Reply

i have a problem in my MDB can any help me to fix it . That msg is apear when i try to run it ( The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. (Error 3197)
Is there any Help for it .
Ashraf

Reply | Quote

Replies

Does this happen always in the same place?

It can happen if you have two different forms open that are trying to change the same record at the same time, or if you try to change a record though code (or an update query) while an unsaved record is open on a form.

Another thing to check is that the ldb file is deleted when you close the database down.

Reply | Quote

Have you tried Tools | Database Utilities | Compact and Repair Database…?

If that, and the suggestions from John don’t help, the database has probably become corrupt. There are some things you can try to repair it, or to salvage as much as possible:

– Download Jetcomp.exe from Jet compact utility is available in download center; this utility can sometimes repair databases that the internal ‘Compact and Repair’ cannot handle.
– Create a new blank database and use File | Get External Data | Import… to import as many database objects from the problem database as possible.
– Try to import the tables into Excel (Data | Get External Data | New Database Query…); the ODBC driver operates at a low level and may be able to get at the data. This won’t retrieve other database objects (forms etc.)

If these fail, you are out of luck. Going back to the most recent non-corrupt backup you have is the best you can do then, but of course, you may have lost some data.

Reply | Quote

i try all the steps that u said hans and also download the Jet compact but all faild . thanks for all
Ashraf

Reply | Quote

i try all the steps that u said hans and also download the Jet compact but all faild . thanks for all
Ashraf

Reply | Quote

Have you tried Tools | Database Utilities | Compact and Repair Database…?

If that, and the suggestions from John don’t help, the database has probably become corrupt. There are some things you can try to repair it, or to salvage as much as possible:

– Download Jetcomp.exe from Jet compact utility is available in download center; this utility can sometimes repair databases that the internal ‘Compact and Repair’ cannot handle.
– Create a new blank database and use File | Get External Data | Import… to import as many database objects from the problem database as possible.
– Try to import the tables into Excel (Data | Get External Data | New Database Query…); the ODBC driver operates at a low level and may be able to get at the data. This won’t retrieve other database objects (forms etc.)

If these fail, you are out of luck. Going back to the most recent non-corrupt backup you have is the best you can do then, but of course, you may have lost some data.

Reply | Quote

Does this happen always in the same place?

It can happen if you have two different forms open that are trying to change the same record at the same time, or if you try to change a record though code (or an update query) while an unsaved record is open on a form.

Another thing to check is that the ldb file is deleted when you close the database down.

Reply | Quote