Skip to main content
Question

Reading/Executing Microsoft Access Queries

  • November 12, 2024
  • 1 reply
  • 22 views

ctmitch
Participant
Forum|alt.badge.img+2

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.

1 reply

bwn
Evangelist
Forum|alt.badge.img+26
  • Evangelist
  • November 12, 2024

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings