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 only known workaround at this time is to always browse to the default database folder when you export an object.

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

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.