HedleySohn


We have a VBA component that we've used for a long time. Our users have recently begun to report that the component no longer runs once they install Office 2007.

We have always created an ODBC workspace as in the following:

DIM workODBC As DAO.Workspace

Set workODBC = CreateWorkspace("ODBCWorkspace", "Admin", "", dbUseODBC)

This call no longer succeeds.

To reproduce this, we set up a VISTA box, and installed Office 2007.

I have ran ComponentChecker and had it "Perform analysis of your machine and automatically determine the release version".

Strangely, it reports back:

The following product releases were matched:

UNKNOWN

The file details show a number of UNKNOWN files:

MSADCOR.DLL

msado15.dll

msadomd.dll

...

...

...

Anyone seen this or have any ideas

Thanks,

HS






Re: CreateWorkspace() call fails after installing Office(Excel) 2007 - using ODBC

HedleySohn


The solution ended up that MSRDO20.dll is not installed in the Office 2007 OEM case.

We copied the file into c:\windows\system32, registered it, and the call began working.







Re: CreateWorkspace() call fails after installing Office(Excel) 2007 - using ODBC

Mark Promislow

Where can I get MSRDO20.dll for VISTA and how do I register it





Re: CreateWorkspace() call fails after installing Office(Excel) 2007 - using ODBC

HedleySohn

In our case it was distributed with VB 6.0. You might have to copy it off of an old Office install if you don't have VB 6.

IMO, this is a bug, in that there is no way for the API call to succeed without the library. I suspect that it will be included in a service pack.

Good luck!