When you try to export a table in MS Access 2000, the process may fail displaying the following error message on your screen:
The Microsoft Jet Database Engine could not find the Object. Make sure the object exists and that you spelled its name correctly.
If you click OK, you get another message on your screen:
An error occurred trying to export the data from table tablename. The data was not exported.
You typically experience such behavior, when the table that you are trying to export contains a self-join and Memo field. Additionally, you have applied referential integrity constraint on that table.
You should perform the following actions to resolve the error:
Try converting all Memo fields contained in the table to Text fields. OR
Take all Memo fields to a different table, and then
Execute a 1:1 relationship between the tables to remove all signs of referential integrity.
The above situation may also occur as a result of Access database corruption. In such circumstances, you need to take help of proficient Access recovery software. Stellar Phoenix Access Recovery is an excellent tool that safely repairs corrupt MDB or ACCDB files to retrieve precious tables, queries, forms (with VBA code), reports, hyper-links, OLE object fields, and other Access database objects. The software supports MS Access 2010, 2007, 2003, 2002, and 2000.
You need to follow the steps given below to recover your corrupt Access database using Stellar Phoenix Access Recovery:
Start Stellar Phoenix Access Recovery. The main interface of the software appears with a Select File dialog box.
In the dialog box, you can either select an Access database or search for Access databases in any specific drive or volume.
Click Select File to select an MDB or ACCDB file. Click Search Files to locate these files after specifying the logical drive to search.
Click Scan File in the same dialog box to begin the scanning process.
After completion of the scan, all recoverable database objects are listed in a tree view in the left pane.
You can click any object to see its preview in the right pane.
Select the objects you need to recover and click Start Repair icon on the tool bar.
A Save As dialog box appears. You can save the file at its default location or any other desired location. After making the choice, click OK.