How to get a java applet to read and display a ms access database?

Question

I created an ms access database but now I need a website to be able to read and be to be able to display table information. I heard this can be done through a java applet how would I accomplish this?

Answer 1

To write your applications, you need Eclipse, java runtime environment, and the java virtual machine. I hope you have a book on java. Eclipse editor can be found through Google. The virtual machine is hard to find, but should be on the same site as the runtime environment, or JDK.



Be Careful, or you won't be happy: All this Eclipse, java runtime, and virtual machine need to be on the same command path, Once everything is installed, you must be able to find the virtualMachine, in explorer, when you first open explorer look, under the tools area, make sure the virtual machine, will open. Now open Eclipse, this is the only way to build applications.



When you see Eclipse is open, read the help area this will tell you how to write java.



You need your applet tags to see the application in html, and xml. These tags are used twice with applets, once in the application. and another time in html, xml.



If you built an html database. you can see these application, as long as they are in the same files as the JDK. It's easiest to keep everything in one fault.

Answer 2

I think I have the solution for your question. First of all, yes you can use a Java applet to access you MS Access database. You do not need any kind of Data base server to do so. Do your studies on JDBC technology from the Java documentation. In your standard distribution of Java SDK, you will have a class called JdbcOdbcDriver. Use this class to make the connection to the data base using ODBC configuration of your system.



Remember that there is no way I can do all the coding for you here. You will have to study your self. Assuming you know Java enough to write your own GUI applets, all you need the JDBC documentation to get started. Good luck with your project.

Answer 3

No, it can NOT be done via Java applet on it's own.

Java applet (read a bit about it) runs in client's browser and has (read about applet security) [nearly] NO access to client's computer and can ONLY connect to the server it was loaded from. So, in order to get any DB info you need (in addition to your applet) at least a DB server (Acess is NOT a DB server) and server side script of some description to process requests from your applet and pass them to DB server and pass results back to your applet...