Error 3197 - When I try to open the Database - VERY URGENT

R

Rui

I tried to compact/rapair with jetcomp.exe, I copied the database to another
PC, I renamed the database and still the same error

Pls Microsoft has a solution for this ?

Thanks
 
A

Allen Browne

Try a decompile.

Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

Then compact:
Tools | Database Utilities | Compact
 
Top