ACC2002: Cannot Use TransferDatabase Action to Link in an Access Project (275092)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q275092
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).

SYMPTOMS

If you use the TransferDatabase action to try to link an external data source in an Access project (ADP), you receive the following error message:
Links can only be created between Microsoft Access database files.

RESOLUTION

You can use the Link Table Wizard to link external OLE DB data sources that use views. For an example of how to do so, follow these steps:
  1. Open the sample Access project NorthwindCS.adp.
  2. On the File menu, point to Get External Data, and then click Link Tables.
  3. Select either Linked Server or Transact SQL to define which type of link you want to create, and then click Next.

    NOTE: Linked Server creates an updateable view; Transact SQL creates a read-only view.
  4. Click +Connect to New Data Source in the Select Data Source dialog box, and then click Open.
  5. In the Data Connection Wizard dialog box, click the Other/Advanced data source, and then click Next.
  6. Click Microsoft Jet 4.0 OLE DB Provider, and then click Next.
  7. Browse to the Northwind.mdb sample Jet database, which by default is installed in the \Program Files\Microsoft Office\Office10\Samples folder, and then click OK.
  8. In the Data Connection Wizard - Choose Data dialog box, click Next, and then click Finish.
  9. When the Link Table Wizard appears, click Table: Categories, and then click the > button to add the table to the Link to Project list. Click Next, and then click Finish.
  10. In the Database window, click Queries under Objects, and note the new view named Northwind_Categories.

STATUS

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

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open any Access project.
  2. In the Database window, click Macros under Objects, and then click New.
  3. Select TransferDatabase in the Action column, and then set the following Action Arguments:

    Transfer Type = Link
    Database Type = Microsoft Access
    Database Name = C:\Program Files\Microsoft Office\Office10\Samples\Northwind.mdb
    Object Type = Table
    Source = Categories
    Destinations = MyLinkedTable
    Structure Only = No

  4. Save and then run the macro.
Note that you receive the error message that is mentioned in the "Symptoms" section of this article.
Modification Type:MajorLast Reviewed:11/6/2003
Keywords:kbbug kberrmsg kbpending KB275092
©2003 Microsoft Corporation. All rights reserved.