I some how go this error after a box came up and said my database needed to
be repaired and I clicked repair and then when I tried to open it I got the
error above. I have a previous version of the data base that opens fine. I am
using Access 2000. Any help that I could get on this would be great. I have a
lot of records in there that I don't have back ups for.

Thanks,
Pete

The database has become corrupt.  You may be able to recover:

backup the mdb

Try compacting your database using Jetcomp, available at
http://support.microsoft.com/?id=273956

If that fails, try creating a new database and importing objects from the
old.  Since it's secured, you'll lose all permissions when you import the
objects, so...

Use the dbUtilities 1.1 at http://www.daiglenet.com/MSAccess.htm to script
out the permissions to a table.
Create a new mdb while joined to your secure mdw.
Import all objects (no MSys objects) to your new mdb.
Use the dbUtilities 1.1 code to reapply the permissions to the objects in
the new mdb.

If that fails, you can try www.pksolutions.com


Show quoteHide quote

Access 2003 security warnings
Inner Joins
Problem switching between Workgroups
Warehouse personnel can't get the needed form - just the backgroun
Opening a previously secured database
Access security question
Undoing Access security
user enviroment needed?
Protect Access database in a Network
Problem opening an Access file from my computer