NOTE: This tutorial will work for Office 2013 and later versions such as Office 2016 and Office 2019. Since the release of Office 2010 version, Microsoft has started using a new virtualization technology to distribute Office setup and installation files to users and the technology is called 'Click-to-Run' or 'C2R Installer'. Microsoft Office is a suite of applications for office productivity including word processing, spreadsheet creation, and presentation development. Requires a DirectX 10 capable graphics card.
* As newer versions of Adobe software are released, additional compatibility testing may be required. GMetrix will always work to support the latest software version of Adobe CC products whenever possible.
** Depending on your software version, Premiere Pro sample documents may require a short conversion process the first time a test is started. This will not impact your test timer.
Connectivity to Office documents on 64 bit platforms
Article ID: 255 - Updated: Feb 9, 2021 - Products: All products - Version: V6 - Category: License and Activation
Problem
Before you can use data from Microsoft Office files such as MS Access (*.mdb and *.accdb) and MS Excel (*.xls, *.xlsx, and *.xlsb) in NiceLabel, you must have appropriate database drivers installed. When you install MS Office, appropriate database drivers also install.
If you don't have Microsoft Office installed, you must install database drivers yourself. Microsoft offers the 'runtime/redistributable' packages for download. Microsoft Access Database Engine 2010 Redistributable for download. Installing this software adds the necessary ODBC and OLE DB drivers. Bluestacks offline installer for pc. The redistributable package exists in two flavors, as 32-bit and 64-bit installation. The version you would install depends on the application that will connect to the Office data files.
You can download the database drivers from Microsoft:
- For Microsoft Office 2016.
- For Microsoft Office 2013.
- For Microsoft Office 2010.
Solution
When to choose 32-bit or 64-bit version of Microsoft Access Database Engine 2010 Redistributable?
If you have 32-bit system, all NiceLabel products run in 32-bit mode. You can only install 32-bit version of Database Engine.
If you have a 64-bit system, most of the NiceLabel applications run in 64-bit mode, but Automation Builder runs in 32-bit mode. Automation service auto-determines the Windows system version and runs as 32-bit or 64-bit. When you test your triggers in Automation Builder, they might not function the same in Automation service, because the service uses 64-bit database drivers.
In this case, you must install 64-bit version of the Database Engine on the machine that has NiceLabel Automation service installed.
What can I do to use NiceLabel designers and Automation service on the same machine?
When you use the same machine to configure your triggers in Automation Builder and execute triggers in the Automation service, you must have installed support for 32-bit and 64-bit database drivers.
To have both database drivers installed on the same system, you must have Microsoft Office installed. It doesn't matter which version of Microsoft Office you have, it can be 32-bit or 64-bit. The key point is that you install Microsoft Access Database Engine 2010 Redistributable of the opposite 'bitness'. If you have 64-bit Microsoft Office, then install Microsoft Access Database Engine 2010 Redistributable 32-bit:
- Go to the Microsoft download page.
- Select:
- 'AccessDatabaseEngine.exe' to install 32-bit driver or
- 'AccessDatabaseEngine_x64.exe' to install 64-bit driver
- Start Command Prompt (CMD) 'as administrator'.
- In CMD navigate to the location of your Microsoft Database Engine.
- Add the following text:
Can I install Microsoft Access Database Engine 2010 Redistributable 32-bit and 64-bit on the same machine?
No, you cannot have Microsoft Access Database Engine 2010 Redistributable 32-bit and 64-bit installed on the same machine.
To have support for 32-bit and 64-bit Office database drivers, you must install Microsoft Office and Microsoft Access Database Engine 2010 Redistributable of the opposite 'bitness'.
Windows 10 Compatible Microsoft Office
I have Microsoft Office 2013 installed. Can I couple it with Microsoft Access Database Engine 2010 Redistributable?
While it is technically possible to install Office 2013 and Database Engine 2010, the drivers will install with different versions.
When you use 32-bit applications to create labels or Automation configuration, the connection string also encodes the version of the data provider. For example, database drivers for Office 2007 install as version 10.0, for Office 2010 they install as version 12.0, for Office 2013 they install as version 15.0.
If you have Office 2013 32-bit installed, the designers will encode version 15.0 in the connection string. If you install Database Engine 2010 64-bit, the Automation service will seek provider version 15.0, but only 12.0 will be available as 64-bit provider.
: https://www.microsoft.com/en-us/download/details.aspx?id=13255
This Installation Requires A Compatible Microsoft Office
Print documentEmail document
