Queries

[hinser13]

I have a main database and a tablet field version to capture data.

If I use a query to export data from the main system to the tablet, what type of query should I use to import this data from the tablet back into the main system when I return to the office? Append? Update?

System overview: I export the data from the main system as a xls spread sheet into a folder and then import this data into the tablet from the folder. I need to be abble to then import the captured data back into the folder as a xls doc and then import this into the main system without creating a new record but back into the relevant fields.

Regards

Mark

 

[jzwp22]

...without creating a new record but back into the relevant fields

An append query will create new records, so based on your above comment, it sounds like you will need to run an update query. An update query modifies existing records.

Does anyone else use the main database between the time you export and when you will run the update query?

 

[CBrighton]

If you did the import via VBA you could search the PK / unique ID field (i assume you have some kind of field which has a unique value for each record) and append any new records or update any existing ones.

However if the tablet version of the database is only for updates, and new records are never added via tablet, then this is overkill and I agree with jzwp22 that an update query sounds like the solution.

 

[hinser13]

Yes users may modify data in the main system whilst the tablet is collecting data in the field.

I assume that this will be overwritten?

 

[hinser13]

The tablet is only intended as vessel to collect data remotley from the main system and then import the data collected back into the main system once back in the office.

 

[jzwp22]

Yes users may modify data in the main system whilst the tablet is collecting data in the field.

I assume that this will be overwritten?

Yes, the data will be overwritten. The question is how do you know which change should take precedence?


You may have to look into database sychronization. I have only read about it, but never actually used it. Another option is to use Access in conjuction with Sharepoint to do a web based solution. I have heard that Access 2010 allow better integration with Sharepoint. I don't know how any of that would work with a tablet.