Error 3197

[M.A.]

An Access DB is stored on a server. One of my coworkers made a mistake I suppose and now we can't open de DB on her PC.

Error 3197 occurs!!! even before opening. I found where the problem was in de main program, but can we open de DB again on her PC, with other words, can we overwrite the error, to work again with the db on that PC.

Hope you can help me.

Thx in advance.

 

[Travis]

This Microsoft Knowledgebase article may help:

ACC: Jet Database Engine 3.x Error Messages Due to Corruption
ID: Q182867

 

[M.A.]

reply 3197

I've read this article before. It describes the problem correctly, but it doesn't mention how to cope with it.

Any other suggestion?

Thx anyway ;-)

 

[Travis]

Did you try the JetComp to compile/repair the mdb on the PC?

 

[Alexandre]

You should also try to open a new blank DB and import all your database objects into it.

 

[M.A.]

Did you try the JetComp to compile/repair the mdb on the PC?

The DB does not open, the first thing it does is giving me that error message, so it seems impossible to me to compile/repair the mdb on the pc.

Is there an other way to repair/compile? If so, tell me, I'll try.

 

[M.A.]

You should also try to open a new blank DB and import all your database objects into it.

This is an option I haven't thought of, thx, I'll try it right away.

 

[Travis]

Jetcomp.exe may be able to recover some databases that these utilities could not. This is because the Microsoft Access Compact utility and the CompactDatabase method attempt to open and close a database before attempting to compact it. In certain cases where these utilities may not be able to reopen the database, Compact will be unable to proceed, preventing recovery of the database. Jetcomp.exe does not attempt to open and close the database before compacting, and may be able to recover some databases that the Microsoft Access compact utility and the CompactDatabase method could not.

 

[Alexandre]

If you are really playing your last cards, you may want to try to Decompile your DB. Beware, this is not an officially supported feature. No success garanteed.
Read the following articles before going for that technique:
The real deal on the /Decompile switch
The undocumented decompile feature