BioNumerics 64-bit and MS Access

Question: 
I am trying to import data from an external MS Access database via the Import fields (ODBC) option into a BioNumerics database. When I select the ODBC driver, following error message pops up: “(0:IM014) [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.” What could be wrong?
Answer: 

Please note that the 64-bit version of BioNumerics is not compatible with MS Access. The reason is that Microsoft does not support the 64-bit MS Access database drivers on systems where a 32-bit MS Office version is installed (i.e. the majority of the Windows computers).

For occasional imports from an MS Access database, a workaround is to first export the data to an Excel sheet or text file (either tab-delimited or comma-separated values) and to import this file via the Import fields (Excel file) or Import fields (text file) option, respectively.

If data from an MS Access database need to be imported on a routine basis, we recommend to install the 32-bit BioNumerics version. See also our Knowledge Base article on which BioNumerics version to install.

When creating a new BioNumerics database in the 64-bit version, the option Use MS Access based will be grayed out in the Create new database wizard. If an existing database that connects to an MS Access relational database (i.e. a database that was created earlier with a 32-bit version of BioNumerics) is opened in BioNumerics 64-bit, the database will be automatically migrated to a compatible database engine (either MS SQL Server Express or SQLite).

Package(s):

Applicable for: 
Version 7.5 - 7.6

Category:

Share this: