conecting database

[adityabakle]

Hello

For connecting Access file to programs in Java or VB, one needs to configure the Access file using ODBC (provided in control panel). This task is done explicitly and not through program, Can I know how to do this through program in Java/VB both. Is there any code??

 

[GNUrag]

ODBC is an open standard developed for the purpose of data access by programming architecture other that microsoft's one, like from a java environment... However, data access from ODBC drivers is consistently slow. For Microsoft development environment, you'd better use ADO or Jet. Java based database access can be done using the JDBC:ODBC driver only.

 

[it_waaznt_me]

You Should use Jet 4.0 or greater in VB for Access dbs ..
When you select Jet 4 as your driver you just have to tell the location of your db file and the Table that you wanna use as recordset ...

btw .. If I misunderstood then please clarify it what u reallly wanna do ..