Connecting to Access 2010 file format

Permanently deleted user

April 05, 2012 02:30

Will this be possible in the near future? It appears that Cortex can only connect to a pre-2007 version of Access.

Thanks,

Susan

0

• 

  Permanently deleted user

  April 17, 2012 22:25

  Hi Susan,

  Geocortex can connect to Access 2010 formats without problem.  We use ADO.NET type drivers to connect, and unfortunately, Microsoft has changed the format for the database after 2007.  It used to be the "Microsoft Jet Database Engine" was used to connect to data sources like MDB files.  The engine you'll need to install on the server is available at 

  http://www.microsoft.com/download/en/details.aspx?id=10910. 

  Once you install this, use a connection string in Essentials similar to "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="C:\path\database.accdb;JET OLEDB:Database Password=password".  Be sure to change the path and accdb filename, as well as the password to access it (if one is set). 

  Thanks,

   

  Shawn.

  0

Please sign in to leave a comment.