Database Connector Error: DAO Error Code Source DAO.Fields

Crystal 2011.  When attempting to create a Crystal report using an Access Database data source, and attempting to add a table to the report, I get:

Database Connector Error: 'DAO Error Code: 0xc4f, Source: DAO.Fields, Description:  ODBC -- connectionto "SOTAMAS90" failed."

At this point, I'm not even trying to include the SOTAMAS90 ODBC(RDO) datasource.  Any ideas on why I'm getting this error? 

Parents Reply Children
  • 0 in reply to BigLouie

    Thanks for the response. I finally figured out my issue by just trying to import the AccessDB info directly into Excel and getting a different error message.  But your instincts/experience were right-on regarding a linked in table. The ODBC connection was failing because the MAS90 installation was migrated to a new server.  Once I had the client's AccessDB administrator fix the ODBC connection string to the pass-thru query, all was right again with the world.  Thanks, again!