How Can I solved Error 3197 in Access File (mdb)?

A

Allen Browne

Firstly, close Access.
Open the folder where the mdb file is stored.
Delete any LDB file in that folder.
The LDB contains locking information for the MDB.
If Access crashes, the LDB may contain spurious info.

Then try importing everything into a new database.
Follow the steps for the first symptom in this article:
Recovering from corruption
at:
http://allenbrowne.com/ser-47.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can't open ACCESS2003 database due to error 3197 2
Can not open database (error 3197) 6
How do I correct Error # 3197 ACCESS - two users - same data? 2
Error 3197 for just one user 5
Corrupt db 3
Get Error 3197 when trying to open database in Access 2007 1
error code 3197 1
Cannot open database file - Err 3197 6

Top