Re: late binding to Access 2007

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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




On Mar 18, 1:59 pm, "Ken Snell \(MVP\)"
<kthsneisll...@xxxxxxxxxxxxxxxxxx> wrote:
Perhaps this is what you seek:\

DAO.DBEngine.120

--

Ken Snell
<MS ACCESS MVP>

"Garry Robinson - Access MVP" <vb123dot...@xxxxxxxxx> wrote in messagenews:1174186088.188733.27500@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



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.- Hide quoted text -

- Show quoted text -


.