Contrary to popular belief and documentation, stored parameterized procedures can be done in Access! Here is an example,
PARAMETERS [Title] varchar; SELECT from BOOKS where title like '[Title]*'
Using this method, performance is better then using a dynamic query in code. More imporantantly, queries can be easier to manage by a DBA when stored in the database, rather then being mixed into the application logic, no matter what Programming language is being used (C, Java, Perl, VB, etc).
Connecting from Java's JDBC: http://db.ittoolbox.com/documents/document.asp?i=2136
Back to Databases