I know this is an old and common problem for many people. In fact, I have had this problem for a long time but still have not fixed.
My customer was using our VB6 application with Access 2000 database on a standalone industrial machine. This morning she could not start the application and got an error:
3197 The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
I prompted her to search for any ldb files but she could not find any in the whole hard drive. Then she emailed me the database file.
Of course, I cannot not open it so I cannot do Compact and Repair through Access tool. Then I tried using
VB code to repair it but I still got the same error.
Here are my questions:
1. How to fix the database? Any tools or third party software I can use?
2. What caused the crash?
Please help soon. Thanks.
Jeff