Results 1 to 2 of 2
Thread: Copy or transfer table (2002)
2005-03-31, 22:51 #1
- 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>
2005-03-31, 23:07 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 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.