> 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
[quoted text clipped - 4 lines]
>
> 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.

Signature
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
purpleflash - 19 May 2008 17:50 GMT
> > 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
[quoted text clipped - 22 lines]
> 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!