Can no longer open database

P

Phil

I have been using a MS Access 2000 database without trouble until today,
when I got a message saying there was insufficient memory when trying to
display a form. This was a first, and shutting down other programs did
nothing. So, I turned off and restarted the PC. Now, attempts to open the
database result in the following:

"XXX.mdb needs to be repaired or isn't a database file. Do you want MS
Access to attempt to repair the database"?

I clicked YES.

"You do not have the necessary permissions to use the " object".

I clicked OK.

"xxx.mdb can't be repaired or isn't a MS Access database file".

I clicked OK.

That's it. No more options. Can I ever get this database back? The only
other thing I did out of the ordinary immediately prior to this problem was
I started to install MS Outlook, but then cancelled it. Access works fine
on other databases. I tried "Detect and Repair" out of the Help menu, with
no change. I have been the sole user of the database.

Thank you,

- Phil
 
B

Brian

Phil said:
I have been using a MS Access 2000 database without trouble until today,
when I got a message saying there was insufficient memory when trying to
display a form. This was a first, and shutting down other programs did
nothing. So, I turned off and restarted the PC. Now, attempts to open the
database result in the following:

"XXX.mdb needs to be repaired or isn't a database file. Do you want MS
Access to attempt to repair the database"?

I clicked YES.

"You do not have the necessary permissions to use the " object".

I clicked OK.

"xxx.mdb can't be repaired or isn't a MS Access database file".

I clicked OK.

That's it. No more options. Can I ever get this database back? The only
other thing I did out of the ordinary immediately prior to this problem was
I started to install MS Outlook, but then cancelled it. Access works fine
on other databases. I tried "Detect and Repair" out of the Help menu, with
no change. I have been the sole user of the database.

Thank you,

- Phil
Click to expand...

Sadly your database is corrupt. Since you can't actually open it, most of
the usual methods of attempting recovery can't be used. You could try
Jetcomp (a free download from Microsoft), but I wouldn't really expect it to
work. Your best bet is to create a new database and try importing
everything from the damaged one.

If that doesn't work, I think you will need to resort to a backup. You have
got a backup, right?
 
Top