Append Query

[Jeff]

Hi

The users of the database I created in Access want to upload data that
is entered from a copy of the DB while they're out on the road into the
main DB on the server.

Fine, I know you can link to external tables, etc. My questions: does
the link have to be done each time? They will have a laptop, which will
not be tied to the server (through WiFi) when on the road. So it will
power on with only the local drives when out on the road and will power
up with the servers when in the office.

After linking the tables, I know I have to write an Append query to
upload the data. A couple of questions on that: Do I have to write a
query for each table you want to update? Also does the local BD have to
have all data cleared each time they go out -- or will an Append Query
only add unique records based on some key fields?

Thanks and happy holidays

Jeff

 

[John Vinson]

The users of the database I created in Access want to upload data that
is entered from a copy of the DB while they're out on the road into the
main DB on the server.

Take a look at Replication for this purpose. It's fairly complicated
to set up initially, and adds new fields and space to your database,
but this is precisely the situation for which it was developed.

http://support.microsoft.com/kb/282977

has a knowledgebase article that covers the subject. READ IT
CAREFULLY; replication done wrong can be messy! There's also a
Replication newsgroup, and you can check out the resources at MichKa's
site http://www.trigeminal.com.

John W. Vinson[MVP]

 

[missinglinq via AccessMonster.com]

"replication done wrong can be messy!" which is why, I guess, MS decided to
dump it with AC2007!