Applet + Ms Access

This is a more specific version of my other question. I have created an applet that should communicate with my MS Access database. It works fine when I run it through a compiler, b

Solution 1:

I have actually attempted this sort of thing before. I think your problem lies in the nature of an applet.

Applets are downloaded and run by the client machine, so if the database that you are trying to access exists on the server, the client probably does not have access to the database location on the server. And as we all know, code from the client machine is not to be trusted.

It may be easier to rewrite your page as a servlet, as the servlet lives on the server and presumably has access to the database. Your servlet can then send html and receive form data back and forth between the client and server.

If your heart is set on an applet front end, you could send http messages back to a servlet which would then perform the database operations. This option would be far more secure and a lot easier to implement permission-wise.

Hope this helps, let me know if you have additional questions.