Altium NEXUS Documentation

Using Database Libraries with 32-bit and 64-bit Altium Design Software on the same Computer

Modified by Jason Howie on Sep 9, 2020
This documentation page references Altium Vault, which is no longer a supported product. Altium Vault and its component management features have migrated to Altium Concord Pro.

Database Libraries (DbLibs) are a popular and powerful component management solution. However, when using Microsoft Access as the backend database for your components, there is one important difference between using 32-bit and 64-bit versions of Altium Design Software:

  • 64-bit Altium Design Software (Altium NEXUS 18.0 and later; Altium NEXUS) - requires 64-bit Microsoft Access Database Engine to be able to use MS Access with database libraries (DbLibs).
  • 32-bit Altium Design Software (Altium NEXUS 17.1 and earlier) - requires 32-bit Microsoft Access Database Engine to be able to use MS Access with database libraries (DbLibs).
Typically, the appropriate version of Microsoft Office would be installed, of which Access is a constituent part. However, it is likely that many users will have both 32-bit and 64-bit versions of Altium Design Software running on the same computer. The issue is that Microsoft does not officially support, nor endorse, the coexistence of both 32-bit and 64-bit Office applications and drivers on the same computer.

Altium suggests the following three solutions:

  1. Download and install the 64-bit Microsoft Access Database Engine (2010), alongside your existing install of 32-bit Microsoft Office.

The following procedure can be used to manually install the 64-bit Microsoft Access Database Engine (2010) on a computer that already has 32-bit Microsoft Office installed and running (versions 2007, 2010, 2013, or 2016).

This manual workaround is not required if you already have 64-bit MS Office already installed.

The procedure is as follows:

  1. From a command prompt (run cmd.exe from a Windows search), enter the file path and name of the 64-bit Microsoft Access Database Engine (2010) install file, followed by a space and the switch /passive, for example: C:\Users\<ProfileName>\Downloads\AccessDatabaseEngine_x64.exe /passive. The /passive switch runs the installation without showing any error messages.
  2. When a 32-bit Office application is launched it will detect the presence of the 64-bit driver and display a Reconfiguring message (and launch a process which takes some time). This can be prevented from happening by:
    1. Opening the Registry Editor (regedit.exe from a Windows search).
    2. Browsing to one of the following paths (depending on the version of Office installed):
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths
      HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\14.0\Common\FilesPaths
    3. Locating and deleting or renaming the registry value: mso.dll
Note that if you do not delete or rename the mso.dll registry entry, you will get a Reconfiguring message each time an Office application is accessed.
This workaround will also be needed to install Service Pack 1 of the 64-bit Microsoft Access Database Engine (2010).
  1. Download and install the 64-bit Microsoft Access Database Engine (2010) first, followed by 32-bit version of Microsoft Office (featuring Access).
Note that this solution only works with 32-bit Microsoft Office 2007. It does not work with 32-bit Microsoft Office 2010, 2013, or 2016.

The procedure to install the 64-bit Microsoft Access Database Engine (2010) first, followed by the 32-bit version (2007) of Microsoft Office, is as follows:

  1. Uninstall all 32-bit Office installations (including language packs and so on). If you have installed the 32-bit Microsoft Access Database Engine 2010, or 2016, you must uninstall this too.
  2. Install the 64-bit Microsoft Access Database Engine 2010.
  3. Reboot your computer.
  4. Test if your 64-bit Altium Design Software works with Database Libraries.
  5. Install the 32-bit version of Microsoft Office (2007).
  6. Reboot your computer.
  7. Test if your 32-bit Altium Design Software works with Database Libraries.
  1. Download and install both the 32-bit and 64-bit Microsoft Access Database Engines (download file includes both), when Microsoft Office (with Access) is not available.

The following procedure can be used to manually install both the 32-bit and 64-bit Microsoft Access Database Engines (2010) on a computer that does not have Microsoft Office (with Access) installed.

The procedure is as follows:

  1. From a command prompt (run cmd.exe from a Windows search), enter the file path and name of the 32-bit Microsoft Access Database Engine (2010) install file, followed by a space and the switch /passive, for example: C:\Users\<ProfileName>\Downloads\AccessDatabaseEngine.exe /passive. The /passive switch runs the installation without showing any error messages.
  2. From a command prompt (run cmd.exe from a Windows search), enter the file path and name of the 64-bit Microsoft Access Database Engine (2010) install file, followed by a space and the switch /passive, for example : C:\Users\<ProfileName>\Downloads\AccessDatabaseEngine_x64.exe /passive. The /passive switch runs the installation without showing any error messages, and also allows both engines to be installed.
This procedure is also used to install Service Packs for the Microsoft Access Database Engines.

 

Found an issue with this document? Highlight the area, then use Ctrl+Enter to report it.

Contact Us

Contact our corporate or local offices directly.

You are reporting an issue with the following selected text
and/or image within the active document:
Altium Concord Pro Free Trial

Please Complete the form below to get Free Trial of Altium Concord Pro