I did not create any users/groups and using the default "Admin" account) I tried with following code which works fine if I didnt set any password. that you are not able to connect to database if you set the password for the MS access ? ================== import *; import *; class connect2Access public static void main(String s) } ===================== Am I doing anything wrong? what error is it throwing when u put the password for the access database ? SQLException: [Microsoft][ODBC Microsoft Access Driver] Not a valid password. Jdbc Odbc.create SQLException(Unknown Source) at odbc.
Use one of the standard client libraries for accessing SQL/My SQL from . Regardless if an application is created for internal use, a commercial project, web, or mobile application, slow performance can rapidly lead to project failure.The Access Driver has the same JDBC architecture as the JDBC drivers for My SQL and OLEDB, including Connection, Statement and Result Set objects.Because of this you can now access Access data in an easy, familiar way.The cache database is small, lightweight, blazing-fast, and it can be shared by multiple connections as persistent storage.Caching with our JDBC Drivers is highly configurable, including options for: This powerful caching functionality increases application performance and allows applications to disconnect and continue limited functioning without writing code for additional local storage and/or data serialization/deserialization.Applications then access Access through the Access Driver with simple Transact-SQL.