Access'97: file already in use.
Posted on 1998-04-29
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?