Log in screen appears when accessing a Database with ZebraDesigner Pro | Zebra

Log in screen appears when accessing a Database with ZebraDesigner Pro

Article ID: 13704694

Issue / Question

When you use ZebraDeasigner to connect to Excel .XLS type data files, ZebraDesigner will use database driver "Microsoft Jet 4.0 OLE DB Provider" by default. After October 10, 2017, you might not be able to connect to such data sources anymore.
NOTE: Connection to .XLSX type of Excel files are not affected.

The following would happen in the ZebraDesigner software:
You would see the "Database Login" dialog box, prompting you for the user name and password.

Windows updates from October 10, 2017 are the cause of this issue.

Applicable To

ZebraDesigner Software being connected to database

Resolution / Answer


User is prompted to login when connecting to a Database in ZebraDesigner Pro. If the login dialog is closed and user tries to progress through the wizard, an error may occur stating that the table cannot be opened

If you cancel the login window you get the following error


Workaround 1

Remove the Windows update that causes the problem. Find the update id for your Windows system in the list below and remove it.
·        Windows 10 1703: KB4041676
·        Windows 10 1607 and Windows Server 2016: KB4041691
·        Windows 10 1507: KB4042895
·        Windows 8.1 and Windows Server 2012 R2: KB4041693
·        Windows Server 2012: KB4041690
·        Windows 7 and Windows Server 2008 R2: KB4041681 and KB4041678
To remove the update, do the following:
1.      Open Control Panel.
2.      Navigate to Programs and Features>Installed Updates.
3.      Find the update with the KB number in its description.
4.      Click Uninstall.
Then make sure to temporary disable automatic updates, or Windows will install the update again at next update check.

Workaround 2

Open the .XLS file and save it as a .XLSX file type and connect to that file as that file type does not use the affected JET database driver.

The database driver for the .XLSX file type is installed with Microsoft Office products, but can also be installed separately, if needed.
Download Microsoft Access Database Engine 2016 Redistributable

Download Microsoft Access Database Engine 2010 Redistributable


Cause or Overview

This issue is typically caused by the system not having appropriate drivers to facilitate data transfer between Microsoft Office System files and non-Microsoft Office applications (in our case ZebraDesigner). The likely scenario is that 64bit version of MS Office is installed on a 64bit OS and therefore no 32bit drivers exist on the system to support ZebraDesigner which is a 32bit application


The solution is to install 32bit drivers on the system. This is done by installing the Microsoft Access Database Engine Redistributable files.
The redistributable files can be downloaded from the following link Read More>>

Install them using the /passive switch to allow the 32bit drivers on the 64bit system:


1.  Get to a DOS prompt

2.  Navigate to the directory where you saved the AccessDatabaseEngine.exe file

3.  At the DOS prompt type - 

               AccessDatabaseEngine.exe /passive

Once the installation completes, you should then be able to connect to the Database successfully in ZebraDesigner Pro. The login dialog should not appear. 

Note:  Microsoft Access Database Engine 2013 Redistributable files are not currently available but will be in the future. Installing Microsoft Access Database Engine 2010 Redistributable will work for MS Office 2013.

Note:  The steps above have also been tested and proven to work for anyone using Office 2016

Helpful information

ZebraDesigner Pro v2 Connecting to Database  Read More>>

+ Product Codes

  • 105SLPlus Industrial Printers
  • 105SLPlus Industrial Printers
  • 110Xi4 Industrial Printer
  • 140Xi4 Industrial Printer
  • 170PAX4
  • 170Xi4 Industrial Printer
  • 220Xi4 Industrial Printer
  • 2824 Series Desktop Printers
  • All Surface RFID Label Solution
  • Corporate and Brand
  • Desktop Printers
  • G-Series GK Desktop Printers
  • G-Series GK Desktop Printers
  • G-Series GX Desktop Printers
  • G-Series GX Desktop Printers
  • GK420d Product Printers
  • GK420t Product Printers
  • GK888 Desktop Printer
  • GK888d
  • GK888t
  • GT800 Desktop Printer
  • GX420d Product Printers
  • GX420t Product Printers
  • GX430t Product Printers
  • Industrial Printers
  • MZ Series
  • MZ-220
  • MZ-320
  • P4T Mobile Printers
  • P4T Mobile Printers
  • Print Engines
  • QL Plus Series Mobile Printers
  • QL320 Mobile Printer
  • QL420 Mobile Printer
  • QLn Series Mobile Printers
  • QLn220 Healthcare
  • QLn220 Mobile Printer
  • QLn320 Healthcare
  • QLn320 Mobile Printer
  • QLn420 Mobile Printer
  • R110Xi4 RFID Printer
  • RFID Printers
  • RP4T RFID Printers
  • RP4T RFID Printers
  • RW 220 Mobile Printer
  • RW 420 Mobile Printer
  • RW 420 Print Station
  • S4M Product Printers
  • S4M Industrial Printers
  • Xi Series Industrial Printers
  • ZD410-HC
  • ZD420D
  • ZD420D-HC
  • ZD420T
  • ZD420T-HC
  • ZD500R RFID Printers
  • ZD500R RFID Printers
  • ZD620 Series
  • ZD620D
  • ZD620D-HC
  • ZD620T
  • ZD620T-HC
  • ZE500R RFID Print Engine
  • ZE500R RFID Print Engine
  • ZM400
  • ZM600
  • ZQ510 Mobile Printer
  • ZQ520 Mobile Printer
  • ZT200 Series Industrial Printers
  • ZT210 Industrial Printer
  • ZT220 Industrial Printer
  • ZT230 Industrial Printer
  • ZT400 Series Industrial Printers
  • ZT400 Series RFID Printers
  • ZT410 Industrial Printer
  • ZT410 RFID Industrial Printer
  • ZT420 Industrial Printer
  • ZT420 RFID Industrial Printer
  • ZT510 Industrial Printer
  • ZT610 Industrial Printer
  • ZT620 Industrial Printer
  • ZebraDesigner Pro v2
  • ZebraDesigner;ZebraDesigner Series
  • iMZ Series Mobile Printers
  • iMZ220 Mobile Printer
  • iMZ320 Mobile Printer
  • zp450 Desktop Printer