Connection from SN to MS Access?

I dont have an example but you will probably want to follow the Microsoft Jet OLE DB connection format. Youll have to make sure the proper JAR files are in the lib directory for WAS. I would theorize that you can use the Microsoft SQL Server drivers for JDBC but I dont have a system to test that one. See "Making a Simple Connection to a Database" in this article:
http://msdn.microsoft.com...ibrary/ms378526.aspx

Heres a great over view of the different connection strings for Access:
http://www.connectionstrings.com/access

At the very least you could create a Linked Server on a SQL Server instance to the Access Database via an ODBC connection, you could then address that Access database as if it were a SQL Server instance. Pretty convoluted I know, but it all depends on how desperate you are.

However, using a JDBC-ODBC bridge is a popular way of connecting to Access via JAVA apps and this would require deploying some additional files on your WAS server. Using the Sun bridge your class would be sun.jdbc.odbc.JdbcOdbcDriver and your connection string would be similar to jdbc:odbc:AccessODBCName

Personally I think using Access as an enterprise delivery platform is not ideal, no matter how much Microsoft says they have improved it. If you have the option I say port it over to your enterprise rdbms platform (but then if that was an option you probably wouldnt be posting this question here huh?).

hth
Matt

Matthew: I totally agree with your "Personally I think using Access as an enterprise delivery platform is not ideal, no matter how much Microsoft says they have improved it." statement, but unfortunately "we" (as a company) don't see it that way. We have a developer that loves his Access and that is what he writes most of his apps (that require a db) in.
Coworkers and I have been telling him to port it over to (at the very least) SQL, but he seems to like his little world.

Thank you for the links and the suggestions! I'll let you know if I get something working.
-Greg

All: I am totally brain-dead today. I guess, I'm just no jdbc, or java programmer. Tried following Matt's links above but am struggling. Today screen shots would be welcomed.