Microsoft KB Archive/275092

= ACC2002: Cannot Use TransferDatabase Action to Link in an Access Project =

Article ID: 275092

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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.
 * 1) Click +Connect to New Data Source in the Select Data Source dialog box, and then click Open.
 * 2) In the Data Connection Wizard dialog box, click the Other/Advanced data source, and then click Next.
 * 3) Click Microsoft Jet 4.0 OLE DB Provider, and then click Next.
 * 4) 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.
 * 5) In the Data Connection Wizard - Choose Data dialog box, click Next, and then click Finish.
 * 6) 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.
 * 7) 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.



Steps to Reproduce the Behavior
 Open any Access project. In the Database window, click Macros under Objects, and then click New. 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

 Save and then run the macro.

Note that you receive the error message that is mentioned in the &quot;Symptoms&quot; section of this article.

Additional query words: pra OfficeErrorMessages 10019

Keywords: kberrmsg kbbug kbpending KB275092

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.