Corrupted Project

  • Thread starter Thread starter Robert Robichaud
  • Start date Start date
R

Robert Robichaud

Does anyone have experience on how to recover a corrupted Access 2000
project?

When I launch my ADP, my Startup form does not open. When I try to open
another form, the project shuts down.
 
First, make a backup of your file.

Then, from the menu "Tools", "Database Utilities", try the option "Compact
and Repair Database". You can also create a shortcut and add the option
"/decompile" : this will strips the compilated elements in your database
before opening it and will help a lot with the option "Compact and Repair
Database".

You may also try to create a new database and import all of your elements
from the old database file. If you have Access 2002 or 2003, you can also
try to convert the database to the Access 2002 format then back to the 2000
format (if you want to, of course).

Finally, make a chearch on Google with the words "recovery access database",
you will find services and tools for repairing Access mdb files: maybe some
of them are also able to recover ADP files.

S. L.
 
Thank you for your suggestion but it continues to stop. As soon as I
select the Compact option, it still enounters a program exception and stops.
The same with the /decompile in the shortcut.

If there's a way to copy the source code to an empty .adp, I'd like some
info on how to do it as I've recovered many times with the .mdb this way.
 
The same way as with MDB file: you create an empty ADP file, open it then
choose "Get External Data" (from the File menu) then "Import..." : select
your ADP file and try to import your items. Don't forget to click on the
Options button if you want to import Menus and Toolbars.

When Access is open on the new and empty ADP file, you can also close the
Database window and then choose the Compact option: as you have now no
database opened, it will let you choose an external ADP file to compact and
repair. Maybe this way you won't encounter the program exception.

Also, you may try Access 2002 or 2003 for importing or compacting/repairing
your ADP file.

S. L.
 
Great! I missed the option of creating an empty .adp. Got it to copy the
key components: enough to recover and continue.

Thank you very much for your suggestions.
 
Back
Top