Hello

I have purchased some ActiveX controls that only work with OLE Db specs for
VB 6. I want to use same controls for Access 97. I have two questions:

1.    How to use OLE DB/ ADO with Access 97, I have installed Microsoft Data
Access SDK but do not see any ActiveX control in Access.

2.    How can I distribute my application with ODE with ADO support.

Thank you

Hello

I have purchased some ActiveX controls that only work with OLE Db specs for
VB 6. I want to use same controls for Access 97. I have two questions:

1.    How to use OLE DB/ ADO with Access 97, I have installed Microsoft Data
Access SDK but do not see any ActiveX control in Access.

2.    How can I distribute my application with ODE with ADO support.

Thank you

[This followup was posted to microsoft.public.access.modulesdaovba and a
copy was sent to the cited author.]

Open up any code module, go to Tools/References, and add Microsoft Active
X Data Objects 2.0 Library to your project. There is also a Microsoft
Active X Data Objects Recordset 2.0 Library in my list, sorry I don't
know the difference (if anyone else can explain I'd be curious).

This assumes you have ADO installed on your machine. I'm not sure which
MS products include it - but if you have VB6 then certainly the libraries
are registered.

Distribution - I'm not familiar with the licensing, but physical
distribution would normally be done via the ODE just like any other
external libraries or controls.

Hope this helps!

--
Michael Simcich
AccessTools