When printing or viewing Database Connection Setup in BarTender, you get:
Microsoft Windows Operating System
BarTender Designer (32-bit)
Microsoft JET OLEDB Provider
Any of the following October 2017 Windows Updates are installed
|Operating System||Windows Update Number|
|Windows 10 build 1703||KB4041676|
|Windows 10 build 1607, Windows Server 2016||KB4041691|
|Windows 8.1, Windows Server 2012||KB4041693|
|Windows 7, Windows Server 2008 R2||KB4041681|
We have identified that the problem is in the Microsoft JET OLEDB Provider after installing October 2017 Windows Updates. There is no fix for the JET Provider at this time. The best workaround is to force BarTender to use the ACE Provider instead.
To force BarTender to use ACE you must have ACE installed on your system, and then you must recreate the database connection in BarTender.
To see if you have ACE Installed
Open the Windows Control Panel
Open Programs and Features
Look for "Microsoft Access Database Engine Redistributable"
The presence of this application indicates that you have ACE installed, proceed to "Updating your BarTender Documents"
If you do not have this file, proceed to "Install the ACE Provider"
Advanced users can check for the presense of the this registry key:
HKEY_CLASSES_ROOT\Microsoft.ACE.OLEDB.12.0. If you have that key, then you have ACE installed.
Install the ACE Provider
If you didn't have ACE installed, then follow these steps to install it.
Go to: https://www.microsoft.com/en-us/download/details.aspx?id=13255
Download the file that matches the architecture of BarTender (i.e. 32-bit if you are using 32-bit BarTender, 64-bit if you are using 64-bit BarTender)
Run the executable to install Microsoft Access Database Engine Redistributable
Once installed, proceed to "Updating your BarTender Documents"
Updating your BarTender Documents
Once ACE is installed on the machine, follow these steps to update your BarTender Documents.
Please note steps 3 and 4. You will lose those settings during this process.
Open the BarTender Document affected
Click File > Database Connection Setup
Confirm the location of your Excel file
Check the Query or Filter tabs and make note of any queries or filters that are setup
Remove the current database connection by clicking the Remove button (10.1 and earlier) or the red 'X' button (BarTender 2016)
Click Add to reconnect to your Excel document
Recreate any Queries or Filters that were setup
Repeat these steps for other affected BarTender documents
You may also choose to remove the offending update from your computer. However, please be aware that there are several other important fixes included in those updates. You should review the release notes and your environment carefully before choosing to remove or prevent the Microsoft updates. We recommend that you leave the updates installed until Microsoft comments on the problem.
JET is an older technology used to transfer data between Microsoft Office and other applications (e.g. BarTender). ACE is the replacement for JET and was introduced with new Microsoft Office packages.
BarTender attempts to use the ACE provider whenever it is available. BarTender will always use ACE in the following circumstances:
If you are using a 32-bit version of BarTender with older Excel files, you could be using JET or ACE, depending on your system configuration. When creating a new Database connection, BarTender will default to ACE if it is available. However, the connection preference is stored on a document specific basis.
Therefore, you must remove the documents JET connection and recreate the database connection with ACE installed on your system. From that point on, BarTender will always attempt to use ACE when using that document.
ACE is fully backwards compatible with all version of Excel documents. So there is no harm in updating to the ACE provider. You will still have JET installed on your computer, so any other applications that might need it can still access it (be aware that other applications trying to open Excel via JET will suffer this problem).
We are in contact with Microsoft regarding this issue, but do not have any further information from them.