Java connect to Access

[annie613]

I usually program in VB 6.0 but i was asked if i could develop a Java applet using Borlands JBuilder and connect to a MS Accesss Database....

is there a certain code string that i need to connect

thanks in advance
annie

[annie613]

i am reading the post below on Java and DBs by delta770
i will go from there

any suggestions are still welcomed

thanks :)

[CornedBee]

Access database from an applet is very difficult. The JDBC-ODBC relies on native code and thus may not be used from an applet.

Better to use a MySQL database, especially since you have to connect to a remote DB anyway.

[annie613]

i am new to the whole java thing, but could this be done in an app or someone i was talking to said...servlets, or sockets...

i was confused...

but i maybe albe to handle the application if you think that will work...

and thanks for the suggestion on MySQL....i would rather use that anyway

[CornedBee]

A Java application or a Servlet do not have any restrictions beyond those imposed by the servlet container (configured by you).

An Applet (the stuff running in browsers) has severe security restrictions: you cannot open local files, you cannot connect to anywhere except the originating server, you cannot execute any native code.

I believe there are true Java JDBC drivers for Access by 3rd party vendors. You can use those even from applets. But they are not free like the MySQL driver is.