Access database missing

[Guest]

I lost one of my critical customer databases in Access somehow, it just
disappeared : an error message shows up "The ADP file is not in the correct
format for a Microsaft Access Project? None of the items on the tool bar
works so that I can go to the task pane.

What do I do?

 

[John Vinson]

I lost one of my critical customer databases in Access somehow, it just
disappeared : an error message shows up "The ADP file is not in the correct
format for a Microsaft Access Project? None of the items on the tool bar
works so that I can go to the task pane.

What do I do?

Recover the adp file from your backup disk.

It's apparent that the adp file has become corrupted.

John W. Vinson[MVP]

 

[Norman Yuan]

Addition to John's anwser.

If it is an ADP file (Access Project), the database is not lost just because
of bad *.adp file. ADP file does not store data in it. The database is
actually held by SQL Server/MSDE (either run on your computer or somewhere
on the network your computer connects to). If you cannot get the bad *.adp
file repaired, you can simply create a new *.adp file and connect it to the
database. Of course, in this case, any front end stuff, such as forms,
reports, modules in the *.adp file are lost.