Fungsi Access Database Engine ini adalah untuk membaca Access DB yang berada di versi lebih tinggi, secara default Visual Studio 2012 hanya bisa menggunakan Ms Access 2003 tapi berkat kecanggihan Microsoft Corporation kita bisa mencicipi nikmatnya menggunakan software gratis hehehe.A message appears stating whether or not the test connection was successful.When creating a database, ACCDB is the new default format in Access 2007 and Access 2010.The proper way of connecting to Microsoft Access databases, either the MDB or ACCDB formats, is through an OLE DB connection.
Microsoft Access Database Engine 2007 64 Bit Software Gratis HeheheThough it is technically possible to connect to MDB files through the Add Data dialog box in ArcMap, it is not the recommended workflow. With the new Microsoft Access format, accessing ACCDB files directly through the Add Data dialog box is not possible. Reading these databases requires installation of the correct ODBC drivers. Because of this, it requires 32-bit ODBC drivers to make database connections. If Office 2007 or Office 2010 x86 (32-bit) is installed, the 32-bit Microsoft Access Database Engine is likely already installed. If Office 2010 x64 (64-bit) is installed (or Microsoft Office is not installed at all), the 32-bit database engine must be installed before a connection can be made to Microsoft Access databases in ArcGIS Desktop. It is not possible to install the 32-bit 2010 Microsoft Access Database Engine if 64-bit Microsoft Office 2010 is installed. This is a limitation as described in Microsoft Article 2269468. In this scenario, the 2007 Microsoft Access Database Engine can be installed. The 2007 engine can read both 2007 and 2010 Access databases for OLE DB purposes. For more information on 20072010 ACCDB compatibility, review the Microsoft Developer Network article: Backward compatibility between Access 2010 and Access 2007. If the Microsoft Access Driver lists.mdb and.accdb, then the correct drivers are installed. If the Microsoft Access Driver only lists.mdb, the necessary driver is not installed. ![]() Otherwise, the 2010 Access Database Engine (32-bit) can be installed. After installing the engine, several new drivers appear in the ODBC Data Source Manager, including drivers that are able to read.accdb files. The Microsoft Access Driver now lists.accdb as a file type it supports. To locate this utility using ArcGIS 10 or older, see the 10.0 Web help document Adding OLE DB connections. In the Data Link Properties dialog box, select the Microsoft Office 12.0 Access Database Engine OLE DB Provider. The Microsoft Office 12.0 Access Database Engine Provider was installed with either Microsoft Office or the Access Database Engine. For Step 1, Data Source, either type or copy and paste the location to the ACCDB file. The ability to browse to an ACCDB file in this dialog box is a Microsoft limitation that cannot be addressed by Esri.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |