ACC2: Error Opening/Attaching Paradox in Multiuser Environment

• Microsoft Access version 2.0

SYMPTOMS

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

If one user attaches a Paradox table and opens it, a second user who tries to attach the same table receives the error message:

   Another user has the file open with a different network control file
   or locking style.

CAUSE

This problem can occur if the setting in the ParadoxNetPath entry in the [Paradox ISAM] section of the MSACC20.INI file is in lowercase letters. For example,

   [Paradox ISAM]
   ParadoxNetPath=c:\access

RESOLUTION

To correct this problem, change the setting in the ParadoxNetPath entry to uppercase letters. For example,

   [Paradox ISAM]
   ParadoxNetPath=C:\ACCESS

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Problem

1. To reproduce this problem using two computers, change the setting in the ParadoxNetPath entry in the [Paradox ISAM] section of the MSACC20.INI file on one of the computers to lowercase letters. Leave the setting in uppercase letters on the other computer.

2. Start Microsoft Access on the computer with the MSACC20.INI file containing the ParadoxNetPath setting with uppercase letters. Attach the Paradox file and open the table.

3. Start Microsoft Access on the second computer and try to attach the Paradox file. You receive the error message stated above.

4. Close the table on the first computer and attach the file on the second computer.

5. Open the table on the first computer.

6. Try to open the table on the second computer. You receive the same error message again.

REFERENCES

For more information about attaching Paradox tables, search for "Paradox files," and then "Importing and Attaching Paradox Tables" using the Microsoft Access Help menu.