Microsoft ADO Ext. 2.7 for DLL and Security

[LGarcia]

Hi all,
I inherited an AXP database that references Microsoft ADO Ext. 2.7 for DLL
and Security. When I try to use this database on a newer machine I find that
there are errors and that the aforementioned reference is listed as missing.
When I look down the list I find Microsoft ADO Ext. 2.8 for DLL and Security
on the newer machines. I check it but there are still errors. Is there a way
to tell Access to use whatever version of this reference that is available?
TIA,
LGarcia

 

[Douglas J. Steele]

Try using Late Binding, so that you don't actually have to set a reference,
but instead use CreateObject to instantiate the object for you.

Tony Toews has some information about Late Binding at
http://www.granite.ab.ca/access/latebinding.htm