Office/access 2013 extension support for XBASE/DBF files

After the latest Access 2013 installation, the DBF file cannot be linked to read, the previous version of Access 2010, if the previous project with Access to link a large number of DBF files,

After you upgrade Access 2013, you will get an error accessing the table that links the dbf file by installing the run-time environment for access 2010, and then changing the registry.

My environment is Win7 64bit + Office plus 64bit.

1. Download the support environment for access 2010 Accessdatabaseengine_x64.exe

https://www.microsoft.com/en-us/download/details.aspx?id=13255

2, modify the registry, save the following file as a Merge.reg file, double-click the file to import the registry.

Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\software\microsoft\office\15.0\access Connectivity engine\engines\Xbase]"Win32" = "C:\\progra~1\\common~1\\micros~1\\office14\\acexbe." DLL "" Mark "=dword:00000000" Dbcsstr "=hex:01" Date "=" MDY "" Exact "=hex:00" Deleted "=hex:01" Century "=hex:00" CollatingSequence "=" Ascii "" datacodepage "=" OEM "" NetworkAccess "=hex:01" PageTimeout "=dword:00000258[HKEY_LOCAL_MACHINE\software\microsoft\office\15.0\access Connectivity engine\ISAM Formats] [HKEY_LOCAL_MACHINE\software\microsoft\office\15.0\access Connectivity Engine\ISAM Formats\dBASE 5.0]"Engine" = "Xbase" "exportfilter" = "dBASE 5 (*.dbf)" "Importfilter" = "dBASE 5 (*.dbf)" "Canlink" =hex:01 "onetableperfile" = Hex:01 "Isamtype" =dword:00000000 "Indexdialog" =hex:00 "Createdbonexport" =hex:00 "Supportslongnames" =hex:00[HKEY_LOCAL_MACHINE\software\microsoft\office\15.0\access Connectivity Engine\ISAM Formats\DBASE III]"Engine" = "Xbase" "exportfilter" = "dBASE III (*.DBF)" "Importfilter" = "dBASE III (*.DBF)" "Canlink" =hex:01 " Onetableperfile "=hex:01" Isamtype "=dword:00000000" Indexdialog "=hex:00" Createdbonexport "=hex:00" Supportslongnames "=hex:00[HKEY_LOCAL_MACHINE\software\microsoft\office\15.0\access Connectivity Engine\ISAM Formats\DBASE IV]"Engine" = "Xbase" "exportfilter" = "dBASE IV (*.DBF)" "Importfilter" = "dBASE IV (*.DBF)" "Canlink" =hex:01 "Onetableperfile "=hex:01" Isamtype "=dword:00000000" Indexdialog "=hex:00" Createdbonexport "=hex:00" Supportslongnames "=hex:00

Precautions:

1, if the 32bit Office 2013 is installed in Win7 64bit, you need to download the 32-bit accessdatabaseengine_x32.exe.

Refer to this article: http://jonwilliams.org/wordpress/2014/03/21/enabling-xbase-dbf-support-in-microsoft-office-access-2013/

2, the contents of the registry are replaced with the following:

Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\software\wow6432node\microsoft\office\15.0\access Connectivity engine\engines\Xbase]"Win32" = "C:\\progra~2\\common~1\\micros~1\\office14\\acexbe." DLL "" Dbcsstr "=hex:01" Mark "=dword:00000000" Date "=" MDY "" Exact "=hex:00" Deleted "=hex:01" Century "=hex:00" CollatingSequence "=" Ascii "" datacodepage "=" OEM "" NetworkAccess "=hex:01" PageTimeout "=dword:00000258[HKEY_LOCAL_MACHINE\software\wow6432node\microsoft\office\15.0\access Connectivity engine\ISAM Formats] [HKEY_LOCAL_MACHINE\software\wow6432node\microsoft\office\15.0\access Connectivity Engine\ISAM Formats\dBASE 5.0] "Engine" = "Xbase" "exportfilter" = "dBASE 5 (*.dbf)" "Importfilter" = "dBASE 5 (*.dbf)" "Canlink" =hex:01 "onetableperfile" = Hex:01 "Isamtype" =dword:00000000 "Indexdialog" =hex:00 "Createdbonexport" =hex:00 "Supportslongnames" =hex:00[HKEY_LOCAL_MACHINE\software\wow6432node\microsoft\office\15.0\access Connectivity Engine\ISAM Formats\DBASE III]"Engine" = "Xbase" "exportfilter" = "dBASE III (*.DBF)" "Importfilter" = "dBASE III (*.DBF)" "Canlink" =hex:01 " Onetableperfile "=hex:01" Isamtype "=dword:00000000" Indexdialog "=hex:00" Createdbonexport "=hex:00" Supportslongnames "=hex:00[HKEY_LOCAL_MACHINE\software\wow6432node\microsoft\office\15.0\access Connectivity Engine\ISAM Formats\DBASE IV]"Engine" = "Xbase" "exportfilter" = "dBASE IV (*.DBF)" "Importfilter" = "dBASE IV (*.DBF)" "Canlink" =hex:01 "Onetableperfile "=hex:01" Isamtype "=dword:00000000" Indexdialog "=hex:00" Createdbonexport "=hex:00" Supportslongnames "=hex:00

Win7 32bit installed Office 32bit, the above registry file content value to make the corresponding changes, the principle is that the key path of the registry to match your 2010 installation path,

For example, if these paths are correct:

[Hkey_local_machine\software\wow6432node\microsoft\office\15.0\access Connectivity Engine\ISAM Formats\dBASE IV]

Extrapolate, no longer cited.

Office/access 2013 extension support for XBASE/DBF files