late binding to Access 2007

From: "Garry Robinson - Access MVP" <vb123dotcom@xxxxxxxxx>
Date: 17 Mar 2007 19:48:08 -0700

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.

.

Follow-Ups:
- Re: late binding to Access 2007
  - From: Ken Snell \(MVP\)
- Re: late binding to Access 2007
  - From: Ken Snell \(MVP\)

Prev by Date: Re: optain a list available forms
Next by Date: Re: late binding to Access 2007
Previous by thread: RE: Passing Looking Up Filters from Form to Report
Next by thread: Re: late binding to Access 2007
Index(es):
- Date
- Thread

Relevant Pages

Re: 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)