Microsoft KB Archive/153718

= ACC: Adding a FoxPro Index from a Read-Only Drive Causes Error =

Article ID: 153718

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q153718



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When you try to link a Microsoft FoxPro database with an index from a read-only drive, you may receive the following error message:

Microsoft Access can't create, open, or write to the index file, the information (.inf) file it uses to keep track of dBASE indexes.



CAUSE
You must have read/write permissions for the drive which contains the index file so that Microsoft Access can create the .inf file.



RESOLUTION
You can use one of the following methods to work around this behavior.

Method 1
Place the FoxPro index file on a drive where you have read/write permissions.

Method 2
Link to the FoxPro file without specifying any indices.

Method 3
Place the information (.inf) file on the read-only drive along with the index file and the .dbf file.



MORE INFORMATION
Microsoft Access version 7.0 Help incorrectly states the following:

  If your FoxPro or dBASE tables are stored on a read-only drive or CD- ROM, Microsoft Access can't create an .inf file in the same folder as  the .dbf files. To link a table on a read-only drive, you must specify the path where you want Microsoft Access to create the .inf file in the Windows Registry.

Start the Registry Editor and navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.0 key of the registry.

However, modifying this registry key does not work. Microsoft Access will ignore the registry entry and still try to create the .inf file on the same drive as the indexes.

NOTE: The Microsoft Access 97 Help Index does not contain this message.

