File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Connecting MS Access databse to web using JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connecting MS Access databse to web using JDBC" Watch "Connecting MS Access databse to web using JDBC" New topic

Connecting MS Access databse to web using JDBC

Usman Ali

Joined: Feb 10, 2002
Posts: 1
I have a MS Access database that i wish to connect to the web using JDBC. I have designed a basic web page with a text box and submit button. I wish to be able to query my Access database using the input provided by a user on the web page, and return to the user the information he/she has requested.
I am new to this game and need to know where to start from. I have done a lot of reading around this subject and am confused as I understand there are many ways of doing this.
Obviously my server would need a copy of MS Access and my database. Would i need IIS to be installed on the server as well?
I am a bit confused in terms of where the JAVA coding will go. Will it be on the HTML web page or as a servlet on the server?
All help is greatly appreciated.
Roy Ben Ami
Ranch Hand

Joined: Jan 13, 2002
Posts: 732
well. basically u will need a web server that supports servlets. IIS wont do, but there is a free one called tomcat u can find at the sun site (
your code to connect to the DB will be either in a servlet (which u will call from a jsp page or html page) or in a bean that u will use inside a jsp page.
i recommend trying to read this site for a little bit more background.
Mark Thomas

Joined: Feb 09, 2002
Posts: 4
Actually, Tomcat is located at
All of your Java code will either go into a servlet or a JSP page. I recommend using JSP and calling most of your code from JavaBeans. If you have no clue how to do this then email me and I'll send you some instructions for setting up Tomcat and some source code I have written to do exactly what you want to do. Also, the computer does not have to have MS Access installed on it. You just have to have a copy of the database. If you are using a Windows machine you can use a JDBC-ODBC bridge to connect to your database. Otherwise, you will have to buy a MS Access JDBC driver that is compatible with Linix/UNIX or whatever OS you will be running this application on.
I agree. Here's the link:
subject: Connecting MS Access databse to web using JDBC
jQuery in Action, 3rd edition