Opening Access 2007 in VB6, AccessDatabaseEngine.exe, ACEDAO.dll

[Tony Allan]

We have a VB6 application that has read Access database files for years but
won't read Access 2007 database files on a development machine that doesn't
have Office 2007 installed. This issue has been raised before by several
people in various forums, including Microsoft.

On one development machine I have installed Office 2007, changed the
references in VB6 to the Office suite, removed references to DAO 3.6 and had
no trouble accessing Access 2007 databases.

On another dev machine I have NOT installed Office 2007 because I want to
know what files my users will need if they do not have it. I understand from
Microsoft that I can get the required files by running
AccessDatabaseEngine.exe
(http://www.microsoft.com/downloads/...36-8C28-4598-9B72-EF94E038C891&displaylang=en).
I have done that but it's not sufficient. The database format is not
recognised.

I see that ACEDAO.dll is not included in that package, so I copied it intto
the Office12 folder. However I can't register it. Other developers have
posted the same problem eg
http://www.tech-archive.net/Archive/Access/microsoft.public.access.formscoding/2007-07/msg00442.html. I got your name from there.

So, do you know why it can't be registered, or what other files do I need,
or is this barking up the wrong tree?!

 

[jbooth952]

I have the same problem. When I install a VB6 app that uses DAO for access to
2007 accdb type databases, on a machine that does not have any version of
Access, the program fails.

It works fine on a machine that has the full Access 2007 product, and it
works on the non-access machine, if I only package DAO 3.60 and use access
2003 .mdb databases.

What do you have to reference in VB6 projects to make this work? What needs
to be in the deployment package?

Jim Booth

 

[Tony Allan]

I have fixed the problem myself now. Here it is.

1) Convert databases to 2007 format
2) Run AccessDatabaseEngine.exe on the target machine
3) In VB6 Project|References,
a) Deselect Microsoft DAO 3.6 object library
b) Select Microsoft Office 12 access database engine object library
c) Select Microsoft Office 12 object library
4) no special code changes needed when setting db objects

finis