Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    Micron is offline Very Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,424
    When you choose the link option on source tables that are not linked to anywhere, you are going to affect those tables in the other database assuming you have permissions on the location of the source db. If you import the tables, you have independent copies of them if the source tables are not linked, and if different people are using both of these db's the records will likely differ between them. However, if the tables are linked in the source db (the one you're copying from) your copied tables are linked back to the original source, just like the ones you copied from are, because you cannot import tables from a database as physical tables if those tables are linked - you can only import them as linked tables.



    Let us know when you've had a chance to perform my previously suggested steps (I presume that's what you're up to next).

  2. #17
    Jacquedup is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Posts
    8
    Thank you very much for all the feedback. I found a Access specialist who repaired it for me in 3 hours where the previous company I approached said it would take weeks to get right.

    Thanks for all the input and advice, but I was in a time crunch and had to get someone in.

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

Similar Threads

  1. Replies: 1
    Last Post: 11-15-2016, 02:14 PM
  2. Replies: 1
    Last Post: 11-11-2016, 07:02 PM
  3. Replies: 10
    Last Post: 06-19-2014, 01:51 AM
  4. Help needed : Library catalogue in access format is needed
    By dealers in forum Sample Databases
    Replies: 3
    Last Post: 01-16-2014, 02:03 PM
  5. Replies: 1
    Last Post: 03-09-2009, 12:46 PM

Posting Permissions

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