Can you run a Microsoft Access Macro with Java/JDBC

[maynard444]

I just need to know if there is a way to run a macro or query that is resident in a database in Access. I have found no answer after searching for hours, and It's been a while since I have programmed in JDBC, plus I'm on a time crunch to get it done. Any help would be appreciated. Thanks
Heath

 

[sedj]

Query's in Access I believe are equivalent to a "view" in a *proper* database. They are NOT stored procedures, so cannot be called using CallableStatement.
So if your query is called "Q1" you would execute it thus :

Connection conn; //create your connection using your preferred driver instantiation method / conn pool
Statement s = conn.createStatement();
ResultSet rs = s.executeQuery("select * from Q1");
while (rs.next()) {
   System.out.println(rs.getString(1));
}

This is obvioiusly a very simple example, and will require some work by you to implement it ..