Cannot open Access database

  • Thread starter Thread starter kuben
  • Start date Start date
K

kuben

Hi

I have been working on a database for the past year. While working on
this last week access listed a problem and created a backup and shut
down. When I restarted access and tried opening the original file or
the backup nothing seems to happen. The file and the backup is the same
size but both don't open.

Can anyone please help. I need the entire structure (i.e. tables,
queries, forms, reports, modules etc.) but not the data.

Thanks

Kuben
South Africa
 
Hi

I have been working on a database for the past year. While working on
this last week access listed a problem and created a backup and shut
down. When I restarted access and tried opening the original file or
the backup nothing seems to happen. The file and the backup is the
same size but both don't open.

Can anyone please help. I need the entire structure (i.e. tables,
queries, forms, reports, modules etc.) but not the data.

Thanks

Kuben
South Africa
Click to expand...

I suggest trying to create a new database and then try linking to one of
the bad ones. You may get lucky. In any case you have learned a hard
lesson. Always back up your files.

If my idea does not work, there may be other tricks someone will suggest
and of course if it is worth the cost there are companies that specialize in
recovering data. Not cheap.
 
Hi

I have been working on a database for the past year. While working on
this last week access listed a problem and created a backup and shut
down. When I restarted access and tried opening the original file or
the backup nothing seems to happen. The file and the backup is the same
size but both don't open.

Can anyone please help. I need the entire structure (i.e. tables,
queries, forms, reports, modules etc.) but not the data.

Thanks

Kuben
South Africa
Click to expand...

Check the hints at http://www.granite.ab.ca/access/corruptmdbs.htm.

START WITH A NEW BACKUP! You may need it. Copy *both* your files to a
safe place before you start.

Access databases do become corrupt; sometimes they can be repaired, or
partially salvaged, and sometimes they cannot. Current tested backups
are only optional if you don't mind recreating the entire database
from scratch at a moment's notice. Good luck...

John W. Vinson[MVP]
 
Back
Top