Use a Ms Access Driver from another computer

If you are going to do a client/server app, you just need one driver installed in the server side. The clients then could see the database trough JSP pages or Servlets and all the database stuff is done by the server. In order to achieve this you should download the tomcat/apache server from http://jakarta.apache.org/.

Another way to use just one driver is trough RMI. You create a remote interface and then just call the adequate methods, and the remote object where you have installed the driver makes it all. ( I haven't need to do this, but It could be suitable for you)

Good luck.

rotnacogeid at 2007-6-29 18:33:25 >

>...order to avoid to install this driver on all the computers ...

To use ODBC the ODBC driver appropiate for the database must be installed on each client machine.

There is no other way.

And for MS Access, the ODBC driver requires that each client machine have a mapped drive to the database file.

If this is not acceptable then look at some of the other posts that suggest alternative drivers.

jschell at 2007-6-29 18:33:25 >