Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBCDirect unsupported in Acc2K7?

Status
Not open for further replies.

genomon

Programmer
Aug 20, 2001
2,449
US
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."
 
Never mind. Musta been having another senior moment. Pass-through query works just great for my problem.

"Business conventions are important because they demonstrate how many people a company can operate without."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top