Can't open ADP file

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I have an ADP file that seems to have become corrupted
somehow. When I try to open it I get the error
message "The file is not in the correct format for a
Microsoft Access project". My latest backup of the file is
a few weeks old and I had done significant work on the
file, particularly VBA code, since the last backup. I'm
running Access 2002 SP3 and SQL Server 2000 SP3a.

Does anyone have any ideas how to recover this file, or
know if it possible extract the VBA code from it?

Thanks.
 
You may want to try importing your form, report, and
module objects into a new ADP file and see if that
corrects, if you haven't already.
 
Have you tried opening just Access (no specific database)
and performing Compact Repair Database aginast the
corrupt file?


May or may not be relevant but I had a similar error that
occured in a Access 2000 database. Trying the compact
repair using Access 2000 didn't fix the problem. However
when I opened the Access 2000 database with Access XP I
was able to successfully repair the database. If you
have access to it, you may get lucky trying to repair it
using Access 2003 if the Access 2002 repair utility
doesn't fix it.

Good luck.
- T
 
try the undocument /decompile switch on a copy of your corrupt database,
like this:

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" /decompile
"C:\my\path\to\mydatabase.adp"
 
Thanks for the idea, but I still got the same error. Any
other ideas would be greatly appreciated. Thanks.
 
-----Original Message-----
Have you tried opening just Access (no specific database)
and performing Compact Repair Database aginast the
corrupt file?


May or may not be relevant but I had a similar error that
occured in a Access 2000 database. Trying the compact
repair using Access 2000 didn't fix the problem. However
when I opened the Access 2000 database with Access XP I
was able to successfully repair the database. If you
have access to it, you may get lucky trying to repair it
using Access 2003 if the Access 2002 repair utility
doesn't fix it.

Good luck.
- T

.
 
I tried compact and repair with both Access 2002 and 2003
and got the same error. The jetcomp utility only seemed to
work with .mdb files, not the .adp that I have. Any other
ideas would be appreciated. Thanks everyone.
 
Back
Top