Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17

What is the best way to copy (or mirror) large ODBC linked tables into another database?

  1. #16
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    5,514
    He had to have both PK fields in the foreign table
    Well, that might be the reason that would convince me there's a drawback. Unfortunately, pretty sure when I hummed and hawed about taking my copy of the db manual structure home upon retirement, I think I elected to not do so. Otherwise I'd certainly try to see if that was done everywhere.

  2. #17
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,202
    Quote Originally Posted by bobfmartin View Post
    I currently use make table queries to create copies of 30 ODBC linked (live) tables into another database. I do this weekly so I can create custom access reports from the data in these tables.
    I'm curious as to why you have to make copies (not mirror images) each week to create custom reports? Why can't you use the live data BE - since they are reports.
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 11
    Last Post: 03-21-2018, 12:45 PM
  2. Update from very large ODBC linked table
    By kagoodwin13 in forum Queries
    Replies: 2
    Last Post: 05-25-2016, 07:29 PM
  3. Replies: 13
    Last Post: 10-04-2015, 08:52 AM
  4. ODBC Linked tables Error
    By tpcervelo in forum Access
    Replies: 0
    Last Post: 02-10-2011, 12:40 PM
  5. ODBC Linked Tables Become Unupdateable
    By dollardeveloper in forum Access
    Replies: 0
    Last Post: 04-08-2009, 06:13 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums