file locking

Posted on 2002-05-07
Medium Priority
Last Modified: 2010-05-02
I need to establish whether a file is locked by another user.
Question by:DAVIDW
LVL 43

Expert Comment

ID: 6993735
What sort of a file?

Author Comment

ID: 6993753
LVL 43

Accepted Solution

TimCottee earned 400 total points
ID: 6993762
This is not necessarily as simple as it may seem, a text file may be opened for reading without placing a lock on the file. The best thing to do is basically attempt to place a lock on the file of the type that you require:

On Error Resume Next
Open "MyFile.txt" For Binary Access Write As #1
If Err.Number <> 0 Then
  Msgbox "Error locking file"
  Close #1
End If

This will basically attempt to open the file for binary write. If it succeeds then you can be fairly certain that the file is not locked by any other user.

LVL 49

Expert Comment

ID: 7722352
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept TimCottee's comment(s) as an answer.

DAVIDW, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
DanRollins -- EE database cleanup volunteer

Expert Comment

ID: 7780044
per recommendation

Community Support Moderator @Experts Exchange

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

619 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