late binding to Access 2007

[Garry Robinson - Access MVP]

In Access 2000 and 'Access 97 DBEngine, , I used to be able to late
bind to the DAO library
as follows

Dim dbe As Object

97'
Set dbe = CreateObject("DAO.DBEngine.35")
'2007

Set dbe = CreateObject("DAO.DBEngine.??????")
Else
'Access 2003-2003
Set dbe = CreateObject("DAO.DBEngine.36")


Can anyone tell what the direct reference to the Access 12
(ACEDAO.DLL) file will be (see the ????? above. If anyone kept the
beta release newsgroups for Access 2007, I think I worked it out in
about March 2006 but I have lost that newsgroup downloads.

 

[Ken Snell \(MVP\)]

Garry -

I have the beta newsgroup posts for the "client.access" group, but don't
find any post from you around that timeframe that contains this info. Can
you narrow it down a bit more -- do you recall the topic of the thread?

 

[Ken Snell \(MVP\)]

Perhaps this is what you seek:\

DAO.DBEngine.120

 

[Garry Robinson - Access MVP]

that is the one. thanks Ken and it was great to meet you in Seattle.

So here is my working code

Dim dbe As Object

'Setup a late bound reference to DAO
If accessVersion = wbAccessVer97 Then
'Access 97 DBEngine
Set dbe = CreateObject("DAO.DBEngine.35")
ElseIf accessVersion = wbAccessVer2007 Then
'Access 2007 and beyond

Set dbe = CreateObject("DAO.DBEngine.120")
Else
'Access 2003-2003
Set dbe = CreateObject("DAO.DBEngine.36")

End If

 

[Ken Snell \(MVP\)]

that is the one. thanks Ken

you're welcome

and it was great to meet you in Seattle.

Same here!