wood burning stoves 2.0*
The moose likes JDBC and the fly likes Java & MS Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Java & MS Access" Watch "Java & MS Access" New topic
Author

Java & MS Access

Philip Pross
Ranch Hand

Joined: Jan 17, 2001
Posts: 76
I'm just about to start a new project using java and access. I've done application localy on my pc with the odbc/jdbc bridge, but my question is it possible to do applets that connect to a database (access) on the web. My problem is how do I start this ........ do I need a winnt server, or sql server, do I need to install access on to the server ... ?? I've look over the groups here, and I feel even more confused then when I first though about it.
Phil
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
Philip
I'm just getting into JDBC myself, but as I understsand it you'll need to have a DSN set up on each client machine in order to do this. Each will also have to have the JDBCODBC-bridge too (I think).


Dave
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

you should read of the FAQ's on Java and the JDBC-ODBC bridge at http://java.sun.com/products/jdbc/faq.html
specifically:
http://java.sun.com/products/jdbc/faq.html#3
http://java.sun.com/products/jdbc/faq.html#5
Jamie
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Java & MS Access
 
Similar Threads
Database access for orinary people, ordinary PCs
setting up a server
New user of JDBC - Seeking help
applet not loading
java. security. AccessControlException