407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 6768)

Product Source - Error 3706 When Linking to an Access 2007 Product Source

This information applies to :

Article ID
6768

Created/Updated
May 27, 2009

Category
Product Database


Are you using the most current release of QuoteWerks?
Version 5.5 Build 1
Issue:
When linking to a Microsoft Access 2007 product source, I receive the following Error:

Error opening connection in ConnOpen(): Error(3706) Provider cannot be found. It may not be properly installed. ConnectString=PROVIDER=Microsoft.ACE.OLEDB.12.0;Data Source=[Your database path].accdb;Persist Security Info=False;Jet OLEDB:Database Locking Mode=1;

Cause:

You do not have the 2007 Office System Driver installed on your system. This driver is installed when you install Microsoft Office 2007, and is required to open Microsoft Access 2007 databases.

Solution:

If you want to be able to link to a Microsoft Access 2007 database from your computer, you must either install Microsoft Office 2007, or install the 2007 Office System Driver.

You can obtain the latest version of the driver from Microsoft here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

This download will install a set of components that can be used by applications to access data in the 2007 Office system such as Microsoft Office Access 2007 (mdb and accdb) files and Microsoft Office Excel 2007 (xls, xlsx, and xlsb) files. Connectivity to text files is also supported.



New Search