207.14.67.90 writes:

I'm wondering if there's a way to directly call up forms and/or queries in Access from a web interface through J++. Basically, I don't want to have people starting up a seperate instance of Access every time they need to do I/O with the database.

Jason Fye

209.47.111.2 writes:

Since you want to call up Access forms through a web interface, this sounds more like a Visual Basic solution -- something I know little about.

For a Java solution, you will have to re-create those forms as either straight HTML or Java Applets, and then connect to the database using the JDBC-ODBC bridge. You can use either CGI or Servlets (I like servlets better) to link the web interface to the database connection.

Alternatively, you can dump Java altogether and use C/Perl with ODBC and CGI, but being a Java fan, I wouldn't recommend it.

Note: there are some bugs in using JDBC with Access -- don't know if it's a Sun problem or a MS problem.

hope this helps
Sonal