Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2005
    Thanked 0 Times in 0 Posts

    Copy or transfer table (2002)

    I have a master database on a server with 6 tables in a one-to-many relationship, where new data is added and corrections are made. Users have their own databases on their hard disc with those 6 tables but also other personal tables (not related this time).
    How can they update their hard disc by copying or transferring the 6 tables without running into trouble with the relationship and keep their personal tables ?
    An append query does not work because of the corrections that are occasionally made to the data on the master and a macro with TransferDatabase does not work because of the relationships?
    Can anyone help?
    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Copy or transfer table (2002)

    Welcome to Woody's Lounge!

    Instead of storing copies of the 6 tables in the users' local databases, you could (have them) create links to the tables. That way, the data will always be up-to-date.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts