JDBC call to Query in Microsoft Access
Posted on 2003-03-17
Is it possible to use JDBC to call a Query object in Microsoft Access and retrieve back a ResultSet ?
I tried to use a CallableStatement object and supply it with the name of the Query, but receive a SQLException say that: "Invalid SQL Statement. Expected INSERT, SELECT, UPDATE, PROCEDURE, DELETE". So, I guess my approach is wrong.
Can someone please show me the correct way to do it.