Link to home
Start Free TrialLog in
Avatar of jpas
jpasFlag for United States of America

asked on

Access'97: file already in use.

I have a VB5/Access'97 application used by multiple users. On one network in particular, we have users receiving the error 'Can not use <dbname.mdb>. File aready in use.' It seems to happen when they perform some operation that updates the database. Each user has their own database, which attaches to tables in a central database when the application starts. I'm not certain, but it may start when one users becomes locked up while using the application.

The application is using transaction processing. The database resides on an NT fileserver, and the users are running Windows'95. The central database resides in a shared folder where the users have 'Change' access. I've changed the permissions to 'Full Control' to eliminate the possibility that they don't have enough rights to the folder. They still seem to have problems. The Access file is a secured database, but I don't think that relates to the problem.

With Access'97, the lock file is suppose to be created with the first user entering the database, but I don't see an '.ldb' file when I look in Windows Explorer.

Any solutions to solving this problem?
ASKER CERTIFIED SOLUTION
Avatar of Dalin
Dalin

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Trygve
Trygve

J_Schroeder: See my answer on your question in the Access area.