MS Access VB 6.0 DB connect using API

[mmvraja]

Iam using VB 6.0, MS Access as Data base.
I Want to connect Access using API from VB, with out using DSN.
How to do it. Hence i can install in any system, any directory with out creating dsn in that system.

I also dont want to give the path like ..

c:\somepath\mydb.mdb
since , If i install the program in D:/different Path.access.mdb,
It will say that .mdb does not exixt.

I want it using Windows API functions only.

[axion_sa]

You don't need a DSN to connect to a database.

Dim oConn As ADODB.Connection
 
Set oConn = New ADODB.Connection
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ 
           "Dbq=c:\somepath\mydb.mdb;" & _
           "Uid=admin;" & _
           "Pwd="

[McGenius]

DAO library is also very handy tool when working with MS Access (specifically when db is local).