themaffeo wrote:I agree with bjmarte - you should look into using microsoft's *FREE* (ok, it comes with office, but if you have access, you have office) MSDE database.
If you must use access, the 'queries' can double as stored procedures. Kinda. Sorta. Ok, not really - but they're the closest thing.
well,you are talking about using 'queries',but how to call a query in ACCESS from outside say JSP page with SQL statement,does CallableStatement achieve this kinda purpose?