Hi Mark,
I've had this problem many times, but on a very large Paradox database
with the app written in PAL (Paradox DOS language). I've not had the
problem with my Delphi apps against the same database. My problems were
basically caused by the .lck files not being rewritten correctly, due to
program crash, network burp, etc. I solved most of them in one go by
backing off some of the cacheing in Win and Netware. Slight loss of
performance but much more stable. Remember, this was (still is) a big
DOS app (30 users) with Win9x clients, unlike the environment you have.
You're probably aware of what .net and .lck files are. Here's a brief
snippet I had laying around :
--------------------------------
The .net file gets an entry for every user that runs BDE using the same
network
control file directory. This entry will allow BDE to display messages
like
"Record is locked by userX"
When BDE first accesses a table in a directory it checks the .lck file
in that
directory to place a table open lock. Before it can use the lockfile it
checks
the location of the .net file which is stored in the .lck file by the
session
that created it. If the .net file location is not the same as its
session you
get an error message that the directory is controlled by another net
file.
If there is no .lck file then the session will create one.
All table and record locks get an entry placed in the .lck file along
with an id
that corresponds to each user logged into the .net file.
When the last user closes the last table in a directory the .lck file
should be
deleted.
Old .lck files left behind when they are not properly deleted can be the
source
of error message that a the directory is controlled by another .net
file.
----------------------------------------
There could also be problems with 2 users clashing over private temp
tables. Check designated private directory in BDE etc. There's also some
doco on this area at
http://www.adug.org.au/PastMeetings/Presentations/IRadulescuMay99/BDENetworking.htm
It may give you a lead on something.
HTH,
Craig.
Mark Howard wrote:
> Hi BDE 5.01 Paradox Have had my app in use at umpteen sites around the
> country for more than 2 years now, with few problems. All of a sudden,
> in the last 2 weeks, 3 separate users are reporting problems when
> opening the app "File is locked by another user" even when there are
> no other copies running. Deleting the .LCK files fixes things but can
> anyone shed any light on what circumstances cause these .LCK files to
> be left in the database directory when the app is not running. I have
> checked that the NetDir is set correctly (I think). Any suggestions
> greatly eppreciated Mark
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
