Microsoft KB Archive/128115

= ACC2: Error Opening/Attaching Paradox in Multiuser Environment =

Article ID: 128115

Article Last Modified on 7/5/2002

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q128115



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



SYMPTOMS
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.



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.

