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

ID: Q241471

The information in this article applies to:

Microsoft Access 2000

Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and 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 this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

On the Tools menu, click Options.

In the Options dialog box, click the General tab.

Note the location of default database folder under Default database folder, and then click OK.

Create the following table:


   Table: FPExpTbl
   -----------------
   Field Name:Field1
   Data Type: Text

   Field Name:Field2
   Data Type: Text

On the File menu, click Save. In the Table Name box, type FPExpText, and then click OK.

Switch to Datasheet view, and then add the following records to the table.


   Field1   Field2
   ---------------
      1        a
      2        b
      3        c

On the File menu, click Close.

Make sure the FPExpTbl table is selected in the Database window, and then click Export on the File menu.

In the Save as type list, click ODBC Databases.

In the Export dialog box, type ExpTest, and then click OK.

In the Select Data Source dialog box, click the Machine Data Source tab.

Under Data Source Name, click Visual FoxPro Tables, and then click OK.

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.

Additional query words: pra directory directories fox pro exporting

Keywords : kberrmsg kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug