Re: late binding to Access 2007



Perhaps this is what you seek:\

DAO.DBEngine.120

--

Ken Snell
<MS ACCESS MVP>

"Garry Robinson - Access MVP" <vb123dotcom@xxxxxxxxx> wrote in message
news: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.



.



Relevant Pages

  • late binding to Access 2007
    ... bind to the DAO library ... Dim dbe As Object ... Set dbe = CreateObject ... about March 2006 but I have lost that newsgroup downloads. ...
    (microsoft.public.access.modulesdaovba)
  • Re: run an Access query from windows scheduler
    ... Here is a vb script example using the Windows Scripting host: ... set dbe = wscript.createobject ...
    (comp.databases.ms-access)