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.
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 (http://java.sun.com) 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.
Actually, Tomcat is located at http://jakarta.apache.org 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.