Currently, we are using a handheld unit to collect process data from our line which is then uploaded into our Quality Access database via ODBC link.  we are upgrading computers and plan to change this handheld to a Microsoft Surface Pro 3.

Question:  What would be easiest method to link or upload process data on the Surface Pro to our existing Access quality database.

1.  Put a local copy of our database on the tablet then export to the database or use an append query?

Hi plottster,

Since this question is related to Access database and Cross-platform migration usually need software rebuild for compatibility, our help might be limited.

we suggest you refer to office TechNet forum for more advices because if you have question about Access database on Microsoft platform, you might get more helpful information there

https://social.technet.microsoft.com/Forums/office/en-US/home?category=officeitpro

If you have question about development on Microsoft platform, we suggest you ask for more advices from MSDN forum

https://social.msdn.microsoft.com/Forums/en-US/home?forum=adodotnetdataproviders

Regards

D. Wu