ACC2000: "Microsoft Jet Database Engine Could Not Find the Object" Error Message Exporting Visual FoxPro Table (241471)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q241471
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

When you use the Visual FoxPro ODBC driver, you are unable to export to any folder except the default database folder. When you try to export to any other folder, you receive the following error message:
The Microsoft Jet database engine could not find the object. Make sure the object exists and that you spell its name and the path name correctly.

RESOLUTION

The only known workaround at this time is to always browse to the default database folder when you export an object.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

  1. On the Tools menu, click Options.
  2. In the Options dialog box, click the General tab.
  3. Note the location of default database folder under Default database folder, and then click OK.
  4. Create the following table:
       Table: FPExpTbl
   -----------------
   Field Name:Field1
   Data Type: Text

   Field Name:Field2
   Data Type: Text
  5. On the File menu, click Save. In the Table Name box, type FPExpText, and then click OK.
  6. Switch to Datasheet view, and then add the following records to the table.
       Field1   Field2
   ---------------
      1        a
      2        b
      3        c
  7. On the File menu, click Close.
  8. Make sure the FPExpTbl table is selected in the Database window, and then click Export on the File menu.
  9. In the Save as type list, click ODBC Databases.
  10. In the Export dialog box, type ExpTest, and then click OK.
  11. In the Select Data Source dialog box, click the Machine Data Source tab.
  12. Under Data Source Name, click Visual FoxPro Tables, and then click OK.
  13. In the Configure Connection dialog box, click Free Table directory. Browse to any folder other than the default database folder, and then click OK.
Note that you receive the error message mentioned in the "Symptoms" section.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug kberrmsg kbpending KB241471
©2004 Microsoft Corporation. All rights reserved.