Skip to main content
  • EN

Hello! I'm working with one of our legacy systems built in Microsoft Access, and I need to extract data from a query. So far, the only method I’ve found involves using the system caller and command prompt. Are there any alternative ways to achieve this?

I've tried using the system caller, but I’m encountering security issues with the runtime version. It appears that I need to set the location as trusted, but I can't do that with the runtime alone. We're aiming to avoid installing the full version of Access, so we're limited to using just the runtime.

Reading a Microsoft Access SELECT Query is the same as reading a Table.

Can use a Microsoft Access  Reader or FeatureReader , which uses ADO  (there are dependencies on having on the same machine some ADO runtime libraries)  or using a Microsoft Access (JDBC) Reader or FeatureReader.

Eg. Microsoft Access (JDBC) Reader output from a SELECT Query
 



 

 

Reply


Community Stats

30,143
Posts
114,417
Replies
37,786
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.