VBA program works in Excel 03, not in 10

[wood144]

I have a VBA program that queries and SQL database through an ODBC connection to pull information from my manufacturing database so i can manipulate the data for reports in excel.

This all worked great until i got a new computer that has Windows7 instead of XP And Office 10 instead of 03. When i load the spreadsheet and hit the button that starts the program i receive an error that Excel "Cannot load DLL: MSRDO20.DLL"

My googling has led me to believe that office 10 no longer uses the same RDO or DOA protocols which is why this DLL is not on this computer. I tried to download the dll from DLLdump.com but cannot get it to register. when i use regsvr32 to try to register the dll I get "error code 0x80004005"

I've tried googling for solutions to that error code but to no avail. Does anyone have any ideas how to make this VBA work in Excel 2010?

[Kenneth Hobson]

Are you doing this by code or the manual means?

If by code, try an ADO solution. http://www.erlandsendata.no/english/...php?t=envbadac