Copying a linked table

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • troy_lee@comcast.net
    #1

    Copying a linked table

    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
    Tags: None
    • fredg
      #2
      Re: Copying a linked table

      On Mon, 19 May 2008 08:21:38 -0700 (PDT), troy_lee@comcas t.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

        Comment

        • purpleflash
          #3
          Re: Copying a linked table

          On 19 May, 16:46, fredg <fgutk...@examp le.invalidwrote :
          On Mon, 19 May 2008 08:21:38 -0700 (PDT), troy_...@comcas t.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_linke d
          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!

            Comment

            Previous template Next
            Working...