Which driver for DAO 3.51 code?

  • Thread starter Thread starter CED
  • Start date Start date
C

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.
 
"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.
 
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.
 
That code doesn't use ODBC

Perhaps you'd better step back and explain what you're trying to do.
 
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.
 
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.
 
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.
 
Back
Top