Error 3197 in MS Access 2000

I am using VB6 with Access 2000. All of a sudden I have started receiving the error

 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."  

Everything was working fine but all of a sudden I started receiving this error. I am using DAO3.6
I tried to open the database in Access200 and it doesnot even let me open I cannot import the data in a new database.
I tried Compact and Repair but then as soon as I click on the mdb file it gives me the same error.

I am sure my database is corrupted , is there any way around this problem as I need to retrieve my data..

Experts, Please help!!

Who is Participating?
nico5038Connect With a Mentor Commented:
MS Access database recovery steps:

1) Create a backup of the corrupt database. (Just in case of)

2) Create a new database and use File/Get external data/Import to get all objects of the damaged database.

3) Try these Microsoft solutions:
Repair A97/A2000:
and/or read the article:
ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database;en-us;306204

4) Bit "heavier":
Access decompile:

5) Try a recovery tool:
Access recovery:

6) Ask a company (will cost $$'s ! ) 

Lou DufresneIT Business Analyst CSM / Project ManagerCommented:
After copying the MDB file to another directory as a back up try this.

1. Close the .MDB file
2. Use explorer and find the subdirectory where the .mdb file resides.
3. If there is a .ldb file there delete it.
4. Noe try to open up the .mdb file.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.