JSP and MS Access

[Guest_imported]

Hi All,
I hope someone can help. Our main company intranet web server is a Linux machine running Tomcat. I would like to be able to host an application on this machine that can connect to MS Access database on a Windows 2000 machine. Can this be done? If so, could anyone tell me how? Best regards! Bailey

 

[ChrisCarroll]

to link to an MS Access database from within a Java program is easy-ish:
You need to get hold of JDBC driver for MS Access. I know that

http://www.j-netdirect.com

allows you to download one, although you may have to pay for extended use. You could try other options on

http://java.sun.com/products/jdbc/index.html

You then want a quick intro to how to set up a jdbc connection, which you can get at

http://java.sun.com/docs/books/tutorial/jdbc/index.html

Accessing the windows 2000 machine would have to be done simply by having the Linux box log into the Win machine as a client - unless you can copy the Access database to the Linux machine instead, which might be simpler

Hope that's half way to an answer?

 

[Guest_imported]

Thanks!! That helps a ton.