Access database different format connection problems

L Operating Environment : Win7 64-bit operating system, Office 2016 64-bit, ArcGIS 32-bit, C # program

L Problem Description : The customer put forward the "Pipeline data warehousing" function, the external data (CAD quality control program export standard library) to the spatial database geodatabase, indicating that the external industry database is an unrecognized database.

• resolution process:

There are currently three types of access data formats

1) Microsoft Access Database (2000 format) (*.mdb)

2) Microsoft Access database (2002-2003 format) (*.mdb)

3) Microsoft Access 2007-2016 Database (*.accdb): Depending on the version of Office installed on your PC, but both are 2007+, the default data format for this format is. accdb, which can be changed to an MDB, but essentially does not change the data format.

Check with the CAD developer that the standard library access format is 2007+ format; The connection string used by the Code CS program to connect to the external industry database is microsoft.jet.oledb.4.0, which is changed to microsoft.ace.oledb.12.0, recompile the program, the tester prompts " not registered on the local computer" microsoft.ace.oledb.12.0 "Provider " error message, the Internet query to know

microsoft.jet.oledb.4.0 : proposed earlier, used in 2000 format, 2002-2003 format, and the data engine for Microsoft, does not support the 2007+ format;

microsoft.ace.oledb.12.0 : compatible with all of the above versions of Access, but to take advantage of this feature, you must install the 2007 database Connection component AccessDatabaseEngine.exe on your computer. This number of component bits is related to office installed on your computer, which is Office 64 and this component also downloads 64-bit.

After installation, test the feature again, available;

Cons : If you change all the connection strings in the program to 12.0, you will need to install the 2007 database connection components in your PC, which is a hassle for CS program installation and deployment.

suspect : Tested to install 2016 version of the database connection components, the program is not good use. It is unclear whether the total version of Office installed on the computer requires a separate 2007 component.

Reference website Information:

Https://www.cnblogs.com/jinianjun/archive/2011/12/05/2276679.html

2007 Database connection components: Http://download.microsoft.com/download/7/0/3/703ffbcb-dc0c-4e19-b0da-1463960fdcdb/AccessDatabaseEngine.exe

Access database different format connection problems