ACC: Error: "Couldn't find file" Using TransferDatabase Action

• Microsoft Access versions 2.0, 7.0

SYMPTOMS

When you use the TransferDatabase macro action to import a table from another database or export a table to another database, you may receive the following error message:

   Couldn't find file 'filename'

CAUSE

The error occurs in Microsoft Access version 7.0 if both of the following conditions are true:

• The file name specified in the DatabaseName property does not contain the .mdb extension.
• The StructureOnly property is set to No.

RESOLUTION

Add the .mdb extension to the file name for the DatabaseName property.

MORE INFORMATION

Steps to Reproduce Behavior

1. Create a new database and save it as mytest.mdb on the root folder of drive C (C:\).

2. Close mytest.mdb.

3. Open the sample database Northwind.mdb (or NWIND.MDB in Microsoft Access version 2.0).

4. Create a TransferDatabase macro as follows:

         Macro Action
         ---------------
         TransfeDatabase
   

         Actions
         -------------------------------
         TransferType: Export
         DatabaseType: Microsoft Access
         DatabaseName: c:\mytest
         ObjectType: Table
         Source: Customers
         Destination: Customers
         StructureOnly: No
   

5. Save and run the macro.

REFERENCES

For more information about TransferDatabase, search for "TransferDatabase action," and then "TransferDatabase action" using the Microsoft Access 7.0 Help Index.