Stellar Knowledge Base

Describe the reasons responsible for a failed table export in MS Access 2000 and how to resolve this issue?

November 30, 2018     10962 views     0     0

When you try to export a table in MS Access 2000, the process may fail to display 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 behaviour, 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 Stellar Repair for Access. It is an excellent tool that safely repairs corrupt MDB or ACCDB files to retrieve precious tables, queries, forms (with VBA code), reports, hyperlinks, OLE object fields, and other Access database objects. The software supports MS Access 2016, 2013, 2010, 2007, 2003, 2002, and 2000.

You need to follow the steps given below to recover your corrupt Access database using Stellar Repair for Access:

  • Start the software, the main interface of the software appears with a Browse 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 Browse to select an MDB or ACCDB file. Click Search to locate these files after specifying the logical drive to search.
  • Click 'Repair' in the same dialog box to begin the repairing process. 
  • After completion of the repair process, 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 Repair icon on the toolbar. 
  • 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.

 

User Comments


 

 

Related Articles