Update SQL Server table with local data

问题:

I have a project to create an application in Access 2010 that will use a local table to collect data with a tablet (that does not have wireless where data is being collected from) and then when they get back to location that has wireless connectivity to be able to upload the data.

I have the SQL Server database and tables. Designed the application using linked tables, then converted them to local tables, so I know the design is the same on both.

What is the simplest way to update the sql server tables with the info from the local tables?

回答1:

Probably the most straightforward approach would be to keep the linked tables in the Access application so you would have both local tables (e.g., [Stuff]) and linked tables (e.g. [dbo_Stuff]). When the network connection is available you could use Append queries and/or Update queries to copy the data from the local tables to the linked tables.