Solved

Access'97: file already in use.

Posted on 1998-04-29
2
438 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Paint/Redraw window while dragging 16 86
VBS file using code from 2nd file (txt or vbs) 4 47
MS Access Search and Replace Using VBA 6 92
Add a task in Outlook from access 11 43
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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…

763 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