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

[Guest]

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

 

[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

 

[Steve Schapel]

Rui,

See if the information here is of any help...
http://support.microsoft.com/?id=283849
http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Guest]

Allen

Thanks for your reply, but still problems