Help needed in Java, How to make dynamic link to access DB Options

[smshete]

Hello,
I want to develop a java based application (applet) which can be loaded onto a CD and can be linked to a DB at the backend. The font end must dynamically connect to the Backend every time the CD is loaded and run. The application must not install in the User's PC but must have a plug and play function from the CD itself.

Problem:-
I want to know how to connect DB (Access) dynamically between front end and backend from a CD.
Also I would like to know about some free Java Installers which provide ODBC connectivity as well.

Thanks

[usr.c]

You can do a search for the JDBC-to-ODBC bridge driver in Google. It'll allow you to connect your Java application to any database supporting the ODBC driver.

As far as it being dynamic, you can re-execute the querying of the database, after you establish a connection to the ODBC driver, everytime the CD is run. No installation is necessary. You'll only need to ensure that Access, or whatever other DB you'll be using, is always present on the client's machine.