Microsoft KB Archive/106187

= ACC: TransferDatabase Macro Action Does Not Replace Table =

Article ID: 106187

Article Last Modified on 5/6/2003

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q106187



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
If you use a TransferDatabase macro action to transfer a table with the same name as an existing table in the destination database, the existing table will not be overwritten by the transferred table.



CAUSE
If the destination database contains a table with the same name as the table you are trying to transfer, Microsoft Access will give the transferred table a new name in the destination database. The new name will consist of the original table name plus a sequential number. For example, if you try to transfer a table named Categories to a database that already has a table with the same name, the newly transferred table will be named Categories1.



RESOLUTION
If you want to replace an existing table using a TransferDatabase macro action, you first need to rename or delete the existing table in the destination database.



STATUS
This behavior no longer occurs in Microsoft Access 97.



Steps to Reproduce Behavior
NOTE: The following example assumes that Microsoft Access is installed in the C:\MsOffice\Access folder. If Microsoft Access is installed in a different folder on your computer, modify the example to refer to your Microsoft Access folder.

 Before starting Microsoft Access, in Windows 95 use Windows Explorer (or in earlier versions of Microsoft Windows, use File Manager) to make a copy of the Northwind.mdb (or NWIND.MDB in version 1.x or 2.0) file. Name the copy Northwind2.mdb, and place it in the Microsoft Access folder. Start Microsoft Access. Open the sample database Northwind.mdb.  Create the following new macro, and save it as mcrTest1:

     Macro Name   Action -     mcrTest1     TransferDatabase

mcrTest1 Actions Transfer Type: Import Database Type: Microsoft Access Database Name: C:\MsOffice\Access\Nwind2.mdb Object Type: Table Source: Categories Destination: Categories Structure Only: No                        Run the macro by clicking Run on the Macro menu, and then close the macro.</li> In the Database window, click Table. Note that the original Categories table still exists, and that a new Categories1 table has been added.</li></ol>

<div class="references_section">