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? 

  • 0

    Are you creating a Crystal report from scratch from the Crystal designer? In the Access database do you have data in tables or have you linked in tables from MAS using the SOTAMAS90 DSN?

  • 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!