Improve company productivity with a Business Account.Sign Up

x
?
Solved

for 500pts <> File Locking and Unlocking. How its work?

Posted on 2006-10-21
1
Medium Priority
?
144 Views
Last Modified: 2010-04-30
Hello Experts,
I have a structured file with only 2 records
File name : Gate.dts
Record Length: 3bytes
Structure :
Type Gate
    FileNo As Byte           '1
    atUse As Boolean       '2
End Type


this file open by process 1 (P#2)

Close #400: Open strCachePath & "Gate.dts" For Random Shared As #400 Len = 3

read some data
Get #400, 1, Gate

write some data
    Lock #400, 2
    Gate.atUse = True
    Put #400, 2, Gate
    Unlock #400, 2

This two records are regulary update by a second Process (P#2) say every 30 seconds
Similary P#1 need to  read and write data to Gate.dts
P#1 reading these records every 30 seconds or so

I'd like to give priority to P#2 if I can

now
1) when I reding data do I need to Lock and Unlock?
2) what will hapen if P#2 is writing to Gate.dts record 1 and P#1 want to read it same time? will it crash?

________________________________________
Aditional Information

in this scenario P#1 and P#2 are in different computers connected though network. P#1 act like a server.
some occations there could be more than one clients and can have multiple of P#2 process and Gate.dts.
Gate.dts located in client machines only

0
Comment
Question by:udanabanana
1 Comment
 
LVL 77

Accepted Solution

by:
GrahamSkan earned 2000 total points
ID: 17783342
1) No. Locking is only relevant to writing.
2) No. You can read a locked record.
If you try to write to a locked record, you will can an error, not a crash.
The error is 70, Permission denied.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

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

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

606 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