Exclusive Error

[tries]

I've recently been appointed to maintain a stand-alone Access '97 application that resides in 35 sites across the US. The application has a code database that's linked to a data database. In some sites the data resides on the user's hard drive and other sites the data resides on a Novell shared drive. In 32 of the 35 sites everything works fine. However, in three of the sites they get error 3008 (The table '¦' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically) when performing an import process that imports a text file into a temp table, manipulates the data and appends it to another table. The manipulation process is a series of 6 update and append queries run using the DoCmd function in a module. The error occurs on the 2nd of six queries. The error only occurs if the data resides on the Novell share drive. If we move the data to the hard drive and relink, everything works fine and I don't get the error. Does anyone know why this happens? What can I try to resolve this problem. Is this a permissions problem?

 

[DougP]

I think you know the answer.<br>&quot;...opened exclusively by another user..&quot;<br>On Novell you do not have permissions set correctly.<br>Of course locally you do cause its not on a network drive.<br>I'm not a Novell person (NT)<br>Have a Novell Administrator look at the permissions.<br>