DAO

  • Thread starter Thread starter Jaisol
  • Start date Start date
J

Jaisol

Can I have more than one DAO version installed?

How can I check DAO versions installed?

Thanks.
 
No, you can't. Why do you want to?
I'm just asking because I didn't know it.
In the VB Editor, select Tools | References.
Click to expand...
Great.


What is difference between JET and DAO?

Thanks again.
 
Douglas J. Steele said:
No, you can't. Why do you want to?
Click to expand...

What do you mean, Doug? There can be more than one version of the DAO
object library installed on a computer. I have DAO 3.51 and 3.6
installed on this one.

Now, can you have more than one version selected in the references for
any given database? I guess that you could but I also guess that it
would be very confusing at best. Has anyone you know tried it to see
what happens?
 
Now, can you have more than one version selected in the references for
any given database? I guess that you could but I also guess that it
would be very confusing at best. Has anyone you know tried it to see
what happens?
Click to expand...

VBA won't let you add references to two versions of DAO. It raises an error:
"Name conflicts with existing module, project, or object library".

Just to clarify for the sake of others who may be following the thread ...

Can you have more than one version of DAO installed on a PC? Yes. Can you
have more than one version of DAO referenced within a VBA project? No.
 
Douglas J. Steele said:
Jet stands for "Joint Engine Technology", and refers to a database engine on
which several Microsoft products are built.
http://en.wikipedia.org/wiki/Microsoft_Jet_Database_Engine

DAO stands for "Data Access Objects", and an interface used to get at data,
originally only in Jet database engines, but later data in other RDBMS.
http://en.wikipedia.org/wiki/Data_Access_Objects You can also use ADO
("ActiveX Data Objects") to get at the data, provided you have an
appropriate Provider.
Click to expand...

Just to amplify a bit. DAO was built to work with ODBC drivers, and was not
designed specifically for Jet. However, both early Jet and DAO, and for that
matter ODBC drivers were so intertwined it almost becomes a chicken/egg
scenario. <g>

-ralph
 
Dirk Goldgar said:
What do you mean, Doug? There can be more than one version of the DAO
object library installed on a computer. I have DAO 3.51 and 3.6
installed on this one.

Now, can you have more than one version selected in the references for
any given database? I guess that you could but I also guess that it
would be very confusing at best. Has anyone you know tried it to see
what happens?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...

I confirm that it is possible to have more than one version of that dll
installed (I have three). You can't reference more than one in the same
project though - an error "Name conflicts with existing module..." is thrown
by IDE. This, in fact, applies to any other group of "versioned" libs (e.g.
ADO).

Dmitriy.
 
Brendan Reynolds said:
VBA won't let you add references to two versions of DAO. It raises an
error: "Name conflicts with existing module, project, or object
library".
Click to expand...

Thanks, Brendan. I didn't know that, but it makes perfect sense.
 
Brendan said:
Just to clarify for the sake of others who may be following the thread ...

Can you have more than one version of DAO installed on a PC? Yes. Can you
have more than one version of DAO referenced within a VBA project? No.
Click to expand...

Can you use more than one version of DAO within a VBA project? Yes:

Sub test()

Dim DAO_DBEngine_35
Set DAO_DBEngine_35 = CreateObject("DAO.DBEngine.35")

Dim DAO_DBEngine_36
Set DAO_DBEngine_36 = CreateObject("DAO.DBEngine.36")

End Sub

Jamie.

--
 
Ewww...late binding! :P

(Just kidding. I know it has its place, and I even use it for cases like
below, and version independence.)



Rob
 
Back
Top