2 Replies Latest reply: Jul 6, 2011 7:26 AM by Darrell Butler RSS

Connecting to a MS Access Database

Darrell Butler

Hi, I'm having problems connecting to an Access Database. I'm running on a Windows7 64 bit machine the access database is 2003. In the edit script box, I select ODBC > Connect and would expect to see the option to select a MS Access Database Data Source - this doesn't appear. Therefore I went into control panel / data sources (ODBC) and created a user DSN to allow me to see the database. However when choosing this DSN to see the underlying tables I get the message "The specified DSN contains an architecture mismatch between the Driver and the application" Has anybody got any experience in overcoming this issue ? Many thanks Darrell.