I am working on an application where all of my machine data is in MSSQL and the customer and order data is in access. I can read each individual value OK but running multiple queries to Access is slow and Access is not very friendly when it comes to multi-user access.
What I would like to do is run one query against Access using:
ExecuteQuery() and then store the resulting dataset to SQL where I can do what I want with it. The above function will return between 1 and 8 rows by 8 columns of data
Can this be done now or would this be a feature request?