missing reference: ADO ext. 2.7 for ddl and security

[Guest]

Does anyone know where I can find Microsoft ADO ext. 2.7 for ddl and security?

When I download mdac 2.7 service pack 1 refresh and instakll it, all i get
under tools>references is ado ext. 2.5.
Whe I download mdac 2.8 I get ado ext. 2.8 for ddl and security. Where is
ext. 2.7 for ddl and security?

Thanks in advance for any help you can provide.

Fred Parkinson

 

[Allen Browne]

Hi Fred. I ran into this problem also.

From memory, they both installed into the same folder - something like:
C:\Program Files\Common Files\System\ado\msadox.dll
and therefore overwrite each other. Access then uses the value for the first
version it finds in the registry, and you are hosed.

Locate the msadox.dll file. Right-click to find out which version it really
is. Use regedit to find and destroy the reference to the other libarary in
the registry. Then if necessary, re-register the correct library with:
regsvr32 "C:\Program Files\Common Files\System\ado\msadox.dll"

Someone may have more details on how this should be done, but my experience
is that the 2 libraries do not co-exist peacefully.