Copying Linked Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several tables linked to Access from my company's mainframe. I wanted
to be able to copy those linked tables and paste with new names, so I
wouldn't need to change my queries when switching among different tables. In
Access 2002, I used a "CopyObject" macro to copy those linked tables, which
were pasted as new linked tables. However, in Access 2003, the tables (with
several GB's of data) are being copied directly onto my machine. Is there a
way to get around this, so I can just copy the linked table using a macro?
Thanks.
 
Hi,

The CopyObject action regarding tables has reverted back to how it was used
in Access 97 and prior. What you would need to use is the TransferDatabase
Method.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Thread-Topic: Copying Linked Tables
| thread-index: AcSkz8mwe5hII+kCTMSGe27B0/pkew==
| X-WBNR-Posting-Host: 170.252.248.194
| From: =?Utf-8?B?Q2hyaXNN?= <[email protected]>
| Subject: Copying Linked Tables
| Date: Mon, 27 Sep 2004 13:23:02 -0700
| Lines: 8
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.macros
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.macros:33491
| X-Tomcat-NG: microsoft.public.access.macros
|
| I have several tables linked to Access from my company's mainframe. I
wanted
| to be able to copy those linked tables and paste with new names, so I
| wouldn't need to change my queries when switching among different tables.
In
| Access 2002, I used a "CopyObject" macro to copy those linked tables,
which
| were pasted as new linked tables. However, in Access 2003, the tables
(with
| several GB's of data) are being copied directly onto my machine. Is
there a
| way to get around this, so I can just copy the linked table using a
macro?
| Thanks.
|
 
Back
Top