Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|