i have this situation i am running into that i hope someone will be able
to help.
i have a table A, and two tables B1 and B2
B1 is related to A in one-to-many (one in B1 to many in A)

I am looking for help in connecting with Access from Java.
Do I need a driver for forName?  If so where do I get it, or what is its
name?
How do I connect if the db does not require a uid or pw?

When using a basic user with only data query and update privileges I
cannot get column data from the DatabaseMetaData object returned from
getMetaData() (on a connection using the JDBC Oracle thin driver).
When I use the schema owner with full privileges, I get the column

I'm running a simple select query and when I issue it through the Java
ODBC connection it claims that it returned 12883 rows.  When I run the
same exact query in Query Analyzer, it says 12922 row(s) affected.
What's the reason for this discrepancy?

When I open a database of type RECNO,
myDbEnvironment  = null ;
table_by_integer = null ;
try {

On the bottom of the following webpage it states
http://java.sun.com/products/jdbc/industry.html
If you would like to add or update your JDBC driver entry in the JDBC
driver database, please fill out the submission form.

My company hosts a web site on one internal machine and that site
accesses SQL Server on another internal machine.  Right now we are
using Sun's jdbc-odbc bridge and we want to replace the bridge with a
jdbc type 4 driver.

Is there a need to make jdbc auto-commit false for read only
transactions?
Does it effect performance is any way? How?
Irfan.

1. Where can I download a JDBC driver to connect to Access 97 locally (same
computer)?
2. Does Java 1.5 have a driver for access already?
Cheers