Access Cannot Open CAPITAL Files

Access may be unable to open certain CAPITAL DBF files because the index expression contained in the CDX file is too complex for Access to resolve. This may be a particular issue with the CAPITAL stock file.

You may be able to move the stock.dbf file to another directory and then open the file. (This will prevent, usually, the system attempting to open the paired index/CDX file.) However, this may create an additional problem with Microsoft Access 2002. In particular, when you try to import or link a dBase file you may receive the error message 3015 index not found.

To resolve the issue, follow the steps in the related Microsoft Knowledge Base article to create a registry key to bypass the Borland Database Engine (BDE) and assign the key a value of 2. Although setting this key to a value of 2 allows you to successfully link the dBASE file, this setting can also cause dBASE tables to be linked as read-only. For more information on this topic in general, please consult the Knowledge Base found on the Microsoft web site.

This is the suggested registry code change:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Xbase]

"BDE"=dword00000002

A setting of 2 means always use the ISAM instead of loading the BDE.

Relevant Microsoft Knowledgebase Article numbers:

    Q287428 - ACC2002: Error 3015 "Index Not Found" Error Message When You Try to Link or Import a dBASE File
 

    Q285949 - ACC2000: Error 3015 "Index Not Found" Error Message When You Try to Link or Import a dBASE File
 

    Q230125 - ACC2000: Using dBASE Data with Access 2000 and Jet
 

    Q290867 - ACC2002: Using dBASE Data with Access 2002 and Jet

22/07/01