Just installed Office 2007. Access 2002 mdb seems happy, except for code that was written utilizing the workspace object with the ODBCDirect param. Project references look good. Error message simply states "ODBC Direct is no longer supported". Short of rewriting everything in ADO (which I would have done from the get-go if it was my code), does anyone know of an add-in or patch to get the old code to run in the new environment? Not much love on the web; couldn't find anything with a site search or in the FAQs.
"Business conventions are important because they demonstrate how many people a company can operate without."
"Business conventions are important because they demonstrate how many people a company can operate without."