PQ Systems Knowledge Base

SP: File Already in Use - Error Opening Database on Novell

Revision Date: 2005-09-07

Problem:

When you try to open a database that is located on a Novell NetWare server or that is already opened in another area, you may receive the following error message:

    Unable to open database:
    path_&_name_of_database.sqd
    [PqOio.OpenAccessDb(30)] Could not use";
    file already in use.

Solution:

If a user opens a database and doesn't have create rights for the folder in which the database is located, the Microsoft Jet database engine can't create the locking information file (*.ldb) that is necessary for multiple users to open the database. Therefore, a user who doesn't have create rights opens the database exclusively if a corresponding .ldb file does not already exist. To prevent this behavior, make sure that all users who open the database have read, write, and create rights for the folder in which the database is located. For additional information see http://support.microsoft.com/default.aspx?scid=KB;en-us;q202171.
 

Would you like to...

Print this page Print this page

Email this page Email this page

Post a comment Post a comment

Subscribe me

Add to favorites Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF

User Opinions (0 votes)

No users have voted.

How would you rate this answer?



Thank you for rating this answer.

Related Articles

No related articles were found.

Attachments

No attachments were found.

Continue