Log in screen appears when accessing a Database with ZebraDesigner Pro

Article ID: 13708341

Details


 

Symptom

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

User-added image

If you cancel the login window you get the following error

User-added image

Applies To

ZebraDesigner Software being connected to database

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

Solution

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:

AccessDatabaseEngine.exe /passive

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.

Helpful information

ZebraDesigner Pro v2 Connecting to Database  Read More>>