Hello Experts, please help me.
I use a MS Access 2K split front end/back end database.
The back end has become corrupt.
I can still open the database and access the modules and forms, however, none of the tables are visible. As a result, I can not edit, delete, or modify any table in the back end.
I have attempted to Compact and Repair but receive the following error:
Could not create; design permission for table or query 'MSysAccessObjects'
I also tried the external compact and repair utility on Microsoft's website and it also failed.
I attempted to use a routine to cycle through the tables and then transfer them to an external database and the operation failed after displaying a "Record is deleted" error.
The data in the linked tables can however be viewed from the links in the front end.
I wrote a routine to cycle through each table in the tables collection and then execute a MakeTable query in a blank database, which successfully created new tables with my data. The query however, does not move indices, or anything else that I might need.
As a result, the use the new data I would need to create every index, which would take a very long time. There are approximately 500 tables in the database that is corrupt.
Can anyone help?
How can I repair the corrupt database, or copy indices and anything else I might need to use the recreated data?