ACC97: Copying Linked Table Does Not Create Local Table (162750)
The information in this article applies to:
This article was previously published under Q162750 Novice: Requires knowledge of the user interface on single-user computers.
SYMPTOMS
When you copy and paste a linked table, the resulting new table is also a linked table. This occurs if you use the Copy and Paste commands on the Edit menu, the Save As/Export command on the File menu, the TransferDatabase (with the option to import) macro action or Visual Basic method, or the CopyObject macro action or Visual Basic method.
CAUSE
This behavior differs from earlier versions of Microsoft Access, which
create a local table when you copy and paste a linked table.
RESOLUTION
When you want to create a local copy of a linked table, use a make-table
query based on the original linked table. To do so, follow these steps:
- Start Microsoft Access and create a new blank database.
- On the File menu, point to Get External Data, and then click Link
Tables.
- In the Link dialog box, locate and select the sample database
Northwind.mdb, and then click Link.
- In the Link Tables dialog box, select the Customers table, and then
click OK. This creates a linked table in your database called Customers.
- Create the following new query in Design view based on the Customers
table:
Query: MakeCustomers
----------------------
Type: Make Table Query
Field: Customers.*
Table: Customers
- On the Query menu, click Make-Table Query.
- In the Make Table dialog box, type LocalCustomers in the Table Name
box, and then click OK.
- On the Query menu, click Run. Click Yes when prompted if you are sure
you want to create a new table.
- Close the query. It is not necessary to save the query.
Note that your database contains a new local table called LocalCustomers
with the same data and structure as the linked Customers table.
STATUS
This behavior is by design.
REFERENCES
For more information about using the CopyObject action or method, search
the Help Index for "CopyObject action" or "CopyObject method."
Modification Type: | Major | Last Reviewed: | 9/25/2003 |
---|
Keywords: | kbprb kbui KB162750 |
---|
|