ADO
 

Hi Andreas

ADO version something should be installed with Microsoft Office. If your
users have the same version all is well. If your users have ADO / MDAC 2.7
then your reference to 2.8 will create disasters. If you however set
reference to ADO 2.0 then the reference will upgrade and save itself to
whatever the user have installed. So yes, simply check an ADO reference,
but be careful if you have all the latest stuff on your system because your
users may not.

HTH. Best wishes Harald

"Andreas" skrev i melding
...
Hi,

I need to read/write data to an Access database through Excel. Last time I
did so, I was using Excel 97 and DAO (3.5 or something). I remember we
then
had to install DAO on all machines that were to be using the Excel sheet.

I now have users with Excel 2000 and Excel 2002. If I use ADO instead to
read/write to the access database, can I do so by just selecting
Tools/References and adding ActiveX Data Objects 2.8 Library and then
sending
the Excel file to the users? Or do I have to install a ADO file on all the
machines first ?
I would like to avoid having to install on all the computers, so if
there's
any way of avoiding that - I would be very happy!

Regards,
Andreas