Append Query to Update Network Table

[Nick M via AccessMonster.com]

I am using an append query to add records saved on a laptop to a table that
is on a network drive. The laptop user has limited access to a network
connection. I need to find a method that will allow me to append the new
data from the laptop to the table on the network, and also bring back a
copy of the table to the laptop, as other users may have entered new
records as well, and the laptop user needs to have the most current
information possible given that he/she may only connect to the network once
a week.

I've had no problem updating the table on the network drive, but I am not
sure what the best way to bring the updated table back onto the laptop
woudl be. I've tried deleting the old version of the table and then
copying in the update, but am not able to because the table is used in
relationships.

Thanks in advance for your help.

Nick M

 

[Guest]

You can clear out all the records and append all the ones from the network
copy. Only do this after all records are "synced" to the network and
verified. If there is a question, first create a backup table and verify the
network connection before deleting the records on the laptop.

Hope this helps.

 

[Nick M via AccessMonster.com]

Thank you, this works very well to answer my problem, but brings up an
additional problem. Once the laptop users make additions and changes I
need to have all of this added back to the network table. I have had
success appending new records, but do not know an efficient way to make
modifications to old records update.

Nick M