Hi there,
I searched for quite a while for my exact problem, with no luck. Platform - MS Access 2010.
Here is what I'm trying to do:
We use SAP B1 for all data entry. I have created an MS Access backend with ODBC linked tables. I've then converted those linked connections to local tables, for usability. The Access front end in turn houses the forms, queries, linked tables (to the local tables in backend), etc.
I want to create an updade/insert query of some sort so I can refresh the local tables in the backend to pull in any new data from SAP (SQL server 2008 i believe). How would I go about pulling in only new records from the ODBC connection to the local tables housed in the Access backend?
Thanks much for your help!