Solution or Workaround
While connecting to the Access database, the following error may occur:
Call to SQLDriverConnect recieved error
Return code: -1
Error: [Microsoft][ODBC Microsoft Access 97 Driver]General error
get the expression service
Outdated ODBC driver
WARNING: The instructions below include making changes to essential parts of your operating system. It is recommended that you backup your operating system and files, including the registry, before proceeding. Consult with a qualified computer systems professional, if necessary.
ESRI cannot guarantee results from incorrect modifications while following these instructions. Therefore, use caution and proceed at your own risk.
Download and install the latest drivers for the database. Currently, you can download the MS ODBC drivers from:
You must first accept the license agreement at the bottom of the page. From the next page select for download "Microsoft Data Access Components 2.0 SP2 Redistribution Typical Setup". This pack contains core MDAC 2.0 components including additional OLE DB providers and ODBC drivers for various data sources, including the drivers for Excel and Access.