Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 199138 - Last Review: July 14, 2004 - Revision: 1.1
ACC2000: Copying Linked Table Does Not Create Local Table
This article was previously published under Q199138
Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
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 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.
When you copy a linked table, the normal behavior of Microsoft Access 2000 is to create the copy as a link. This is different behavior than in Access 7.0 and 2.0.
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. You do not have 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.
Steps to Reproduce Behavior
- Complete steps 1 through 4 in the "Resolution" section.
- Select the linked Customers table in the Database window.
- On the Edit menu, click Copy.
- On the Edit menu, click Paste.
- In the Paste Table As dialog box, type CopyOfCustomers in the Table Name box, and then click OK.
Note that the CopyOfCustomers table is also a linked table, which is
linked to the same source table as the Customers table.
APPLIES TO
- Microsoft Access 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate