Solved

Error 3197 in MS Access 2000

Posted on 2004-04-16
2
1,423 Views
Last Modified: 2007-12-19
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 it...so 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!!


0
Comment
Question by:wilkersons
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 54

Accepted Solution

by:
nico5038 earned 500 total points
ID: 10845167
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:
http://support.microsoft.com/support/kb/articles/Q109/9/53.asp
Jetcomp:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q273956
and/or read the article:
ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;306204

4) Bit "heavier":
Access decompile:
http://www.granite.ab.ca/access/decompile.htm

5) Try a recovery tool:
Access recovery:
http://www.officerecovery.com/access/index.htm

6) Ask a company (will cost $$'s ! )
http://www.pksolutions.com/services.htm 

Nic;o)
0
 
LVL 1

Expert Comment

by:Lou Dufresne
ID: 10845734
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.

Lou
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question