I have an Excel 2003 spreadsheet which communicates with an Access 2003 database, which works in WIndows XP / Office 2003, and I'm trying to get it to work in Windows 7 / Office 2010. This is out in production, so ideally I'd like to make no changes to either one of these files.
The problems is the spreadsheet's reference to Microsoft DAO 3.6, which in the XP/2003 world is in C:\Program Files\Common Files\MIcrosoft Shared\DAO. But the W7/2010 world is quite different, I guess -- DAO360.dll, DAO350.dll and DAO2535.dll don't exist any more, so where did all the stuff in the DAO library go?
I've tried adding to the spreadsheet a reference to the Microsoft Access 14.0 Object Library, but that doesn't help -- it won't compile, because it still doesn't know what a Database object is!
Cross-posted here: http://www.mrexcel.com/forum/showthread.php?t=638448
The problems is the spreadsheet's reference to Microsoft DAO 3.6, which in the XP/2003 world is in C:\Program Files\Common Files\MIcrosoft Shared\DAO. But the W7/2010 world is quite different, I guess -- DAO360.dll, DAO350.dll and DAO2535.dll don't exist any more, so where did all the stuff in the DAO library go?
I've tried adding to the spreadsheet a reference to the Microsoft Access 14.0 Object Library, but that doesn't help -- it won't compile, because it still doesn't know what a Database object is!
Cross-posted here: http://www.mrexcel.com/forum/showthread.php?t=638448
Last edited by a moderator: