I have always been able to repair an Access Database using the 'compact and repair' feature. However, this time I've run accross something new that I'm unable to repair -- even when using the repair function in ODBC -- Repair or Compact...

Upon opening the database, I get the following 'prompt': "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time."

My PC is NOT shared so I know it's not another user.

When I used the repair or compact under ODBC, it gave me another error instead upon opening the dbase: "'AOIndex' is not an index in this table"

Does anyone know how to go about 'repairing' this dbase given the aforementioned facts?

Your help is much appreciated...

~Danny

__________________
~Danny

Import your data into another database ASAP. Your system tables are most likely corrupt. MOVE ONLY THE DATA.

hen move all other items into anoter database. What type of chnges were you doing when this happened? Where you in the midle of changing table attributes?



Sal

Yea, I tried that... I created a new dbase and then attempted to import... as soon as i selected the dbase source I received the same message about having another user update at the same time...

... any other suggestions?

thank you for your continued assistance


~Danny

There is a file called JETCOMP.EXE available from the Microsoft website. It will sometimes repair a database that isn't repairable using the normal process. Make sure to make a backup copy of the database before attempting any compact/repair.

HTH,
Mike

If you don't have any luck there, check out www.rogersaccesslibrary.com and go to Other Developers Libraries. Then look for Whittle, Jerry and his extensive paper on corrupted databases.

HTH,

Beth M