Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / May 2008

Tip: Looking for answers? Try searching our database.

Copying a linked table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
troy_lee@comcast.net - 19 May 2008 16:21 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
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
fredg - 19 May 2008 16:46 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 - 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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.