Solved

Access'97: file already in use.

Posted on 1998-04-29
2
435 Views
Last Modified: 2008-03-10
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?
0
Comment
Question by:jpas
2 Comments
 
LVL 9

Accepted Solution

by:
Dalin earned 200 total points
ID: 1434650
J_Schroeder,
Check how your database was opened in the application.
When open the database, generally has the following:
OpenDatabase(dbname, LockforMeOnly, read-only, Connect)
Now, if the 2nd parameter is passed as True, the database is locked, as long as this application does not close the database, others would not be able to open it.
Regards
Dalin


0
 
LVL 12

Expert Comment

by:Trygve
ID: 1434651
J_Schroeder: See my answer on your question in the Access area.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question