By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,136 Members | 1,267 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,136 IT Pros & Developers. It's quick & easy.

Copying a linked table

P: n/a
What is the best way of copying all the records from a linked table
into a replica table that is local on my computer? This is for
development work at home where I can not access the main table. Is a
macro the best way to handle this?

Thanks in advance.

Troy Lee
Jun 27 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Mon, 19 May 2008 08:21:38 -0700 (PDT), tr******@comcast.net wrote:
What is the best way of copying all the records from a linked table
into a replica table that is local on my computer? This is for
development work at home where I can not access the main table. Is a
macro the best way to handle this?

Thanks in advance.

Troy Lee
On your copy of the database front end (that you take home with you),
delete the existing table (this does not delete the table, it only
breaks the link). Note: You can tell if your table is the linked table
if it has an arrow next to the table name.
Then click on File + Get External data + Import.
Navigate to the database that contains the actual back end table.
Select the table. Click on Options. Select Definition and Data.
If you also need to import the back end relationships, click on Import
Relationships.
Click OK.

You now have all the current records in that table on your database,
but it is no longer linked to the other database.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Jun 27 '08 #2

P: n/a
On 19 May, 16:46, fredg <fgutk...@example.invalidwrote:
On Mon, 19 May 2008 08:21:38 -0700 (PDT), troy_...@comcast.net wrote:
What is the best way of copying all the records from a linked table
into a replica table that is local on my computer? This is for
development work at home where I can not access the main table. Is a
macro the best way to handle this?
Thanks in advance.
Troy Lee

On your copy of the database front end (that you take home with you),
delete the existing table (this does not delete the table, it only
breaks the link). Note: You can tell if your table is the linked table
if it has an arrow next to the table name.
Then click on File + Get External data + Import.
Navigate to the database that contains the actual back end table.
Select the table. Click on Options. Select Definition and Data.
If you also need to import the back end relationships, click on Import
Relationships.
Click OK.

You now have all the current records in that table on your database,
but it is no longer linked to the other database.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
An even simpler method which I use for this exact purpose all the
time! Both for Linked Access tables and also Oracle and SQLServer ones
too!

Have a development copy of your database system using local tables but
with linked tables as well!
1/ rename the linked tables to tablename_linked
2/ create make table queries using the link tables as a master!
3/ Call the new table the original table name so all your forms etc.
continue to work
4/ run the query whenever you can be linked and you will have the
latest data!
Jun 27 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.