ACC: "Couldn't Find File" Error Using TransferDatabase Action

ID: Q156075

The information in this article applies to:

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'

The error only occurs when the import and export commands are used with table objects.

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.

NOTE: In Microsoft Access 2.0, the first condition alone causes the error message.

RESOLUTION

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

MORE INFORMATION

Steps to Reproduce Behavior

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

Close mytest.mdb.

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

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

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.

Keywords : kberrmsg kbusage McrGnrl
Version : 2.0 7.0
Platform : WINDOWS
Issue type : kbprb