Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Can't open ADP file

95 views
Skip to first unread message

Joe

unread,
Oct 7, 2004, 10:39:22 AM10/7/04
to
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.

SFAxess

unread,
Oct 7, 2004, 1:42:58 PM10/7/04
to
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.
>.
>

Joe

unread,
Oct 7, 2004, 2:39:53 PM10/7/04
to
I tried that and got the same error message. Anyone have
any other ideas? Thanks.

>.
>

T

unread,
Oct 8, 2004, 1:26:54 AM10/8/04
to
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

>.
>

Dølle Døck

unread,
Oct 8, 2004, 5:51:45 AM10/8/04
to
Try the jetcomp utility.

You can find it here: http://www.kbalertz.com/kb_295334.aspx

Anders

"T" <anon...@discussions.microsoft.com> wrote in message
news:047901c4acf7$6c2266f0$a501...@phx.gbl...

Malcolm Cook

unread,
Oct 8, 2004, 1:05:55 PM10/8/04
to
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"


Joe

unread,
Oct 8, 2004, 2:11:54 PM10/8/04
to
Thanks for the idea, but I still got the same error. Any
other ideas would be greatly appreciated. Thanks.

>.
>

Joe

unread,
Oct 8, 2004, 2:24:09 PM10/8/04
to
>.
>

Joe

unread,
Oct 8, 2004, 2:26:27 PM10/8/04
to
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.

>.
>

Joe

unread,
Oct 8, 2004, 4:30:08 PM10/8/04
to
I've sent the file to a recovery service. Thanks for
everyone's suggestions.

>.
>

0 new messages