SQL query to microsoft access 2010

spetterpoep · Post by **spetterpoep** » Mon Apr 30, 2012 7:15 am

Hello,

Is it possible to send an sql query to microsoft access 2010 as an action?

KS-Soft Europe · Post by **KS-Soft Europe** » Mon Apr 30, 2012 7:44 am

Sure, you may use SQL query action:
http://www.ks-soft.net/hostmon.eng/mfra ... htm#actSQL

Before using SQL query action, you need to create ODBC data source for Microsoft Access database, using ODBC Data Source Administrator (C:\WINDOWS\System32\odbcad32.exe).
Please note: If you are using Windows x64 Edition, you should setup ODBC datasources using 32-bit ODBC Data Source Administrator (e.g. C:\WINDOWS\SysWOW64\odbcad32.exe).

spetterpoep · Post by **spetterpoep** » Mon Apr 30, 2012 8:15 am

KS-Soft Europe wrote:Sure, you may use SQL query action:
http://www.ks-soft.net/hostmon.eng/mfra ... htm#actSQL

Before using SQL query action, you need to create ODBC data source for Microsoft Access database, using ODBC Data Source Administrator (C:\WINDOWS\System32\odbcad32.exe).
Please note: If you are using Windows x64 Edition, you should setup ODBC datasources using 32-bit ODBC Data Source Administrator (e.g. C:\WINDOWS\SysWOW64\odbcad32.exe).

Thanks for the fast reply

It's working

KS-Soft Europe · Post by **KS-Soft Europe** » Mon Apr 30, 2012 8:41 am

Thanks for the fast reply

You are welcome.

It's working

Great