ACC2: Error Opening/Attaching Paradox in Multiuser Environment

ID: Q128115

The information in this article applies to:

Microsoft Access 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.

If the first user closes the table, the second user can attach it. Once both users have attached the same table, if the first user opens the table the second user cannot open it. When the second user tries to open the table, the error message occurs again.

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

Also, make sure that the ParadoxNetPath setting, including the drive letter, is the same on all the computers using the attached table.

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

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.

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.

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

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

Open the table on the first computer.

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.

Additional query words: locking style

Keywords : kb3rdparty kberrmsg IsmPdox
Version : 2.0
Platform : WINDOWS
Issue type : kbbug