Microsoft KB Archive/156075

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

Article ID: 156075

Article Last Modified on 11/17/2000

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q156075



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.



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.</li></ol>

<div class="references_section">