Re: MSAccess get Query SQL source possible

If you have only a few QuerySQL, the quicker wayis to copy all sql
manually in MS Access.
If you need a program solution, you can use HXTT
Access(http://www.hxtt.com/access.html), a commerical JDBCdriver for MS
Access.

ResultSet rs=dbmd.getTables("adb",null ,null, new String[]{"VIEW"});
while(rs.next()){
String viewName=rs.get("table_name");
String sql=rs.get("remarks");
//...
}

.