Which driver for DAO 3.51 code?

[CED]

I have been given this code:

' Reference set to DAO 3.51
Dim db As DAO.Database
Dim wk As DAO.Workspace

DBEngine.DefaultPassword = "mypassword"
DBEngine.DefaultUser = "myuser"
DBEngine.SystemDB = "C:\myfolder\system.mdw"

Set wk = DBEngine.CreateWorkspace
("mine", "myuser", "mypassword")
Set db = wk.OpenDatabase("C:\myfolder\mydb.mdb", False,
False)

How do I determine which driver it uses?

Thank you.

 

[Douglas J. Steele]

"Driver" in what sense? That's VBA code, and to make it work, you'd need to
set a reference to the Microsoft DAO 3.51 Object Library.

 

[CED]

Driver as in 'odbc driver'. I have assumed it is using
odbcjt32.dll. Is this a safe bet? Or can I get the
reference to DAO 3.51 to tell me which odbc driver? Or
does DAO not use odbc drivers?

Thanks again.

 

[Douglas J. Steele]

That code doesn't use ODBC

Perhaps you'd better step back and explain what you're trying to do.

 

[CED]

So if I uninstall/unregister/delete the odbcjt32.dll
Access Driver, the DAO code will still function?

Stepping back, I'm trying to determine dependencies e.g.
does DAO 3.51 need/use odbcjt32.dll (or other independent
driver etc.)

Thanks for your on-going help.

 

[Douglas J. Steele]

DAO 3.51 doesn't use ODBC, although I believe ODBC can use DAO 3.51

Why do you need to know the dependencies? If it's because you want to be
able to communicate with a Jet database on a computer that doesn't have
Access installed, you can install the Jet 3.51 Service Pack to get
everything you need.

 

[CED]

I know a machine currently uses DAO 3.51, as confirmed by
the code snippet I have gleaned. Can I be sure the same
machine currently has a use-able odbcjt32.dll, based on
the fact the DAO 3.51 code is currently working? Your last
reply suggests I cannot.

Thank you once again.