multi user access to 1 data file
chris at faredge.com.au
Sat Jan 27 22:49:50 GMT 2001
Here's some advice I received which fixed up my problems:
Yeah I'm becoming more confident every day... (fingers crossed).
The problem appears to be that the MYOB doesn't use any of the
file locking semantics provided by windows, so VREDIR.VXD caches
the Premier datafile. It doesn't take long to see how with multiple
users, that data file can get corrupted. The caching algorithm was
changed a few times throughout the life of Win95, and Win98 is a
big improvement, which is why you probably aren't seeing the
problem with the Win98 boxes.
The MS knowledge base articles that I found most helpful are Q152186,
Q148367, Q174371, Q142803.
I just upgraded to vredir.vxd version 4.00.1116 and set up a registry key
which is detailed in some of those knowledge base articles.
I have attached the VREDUPD.exe file which includes the vredir update.
I also turned off oplocks and level2 oplocks on Samba to make sure that the
Samba locking didn't get in the way, which I think was probably
Let me know if you need anything else.
From: samba-admin at lists.samba.org [mailto:samba-admin at lists.samba.org]On
Behalf Of dkwok
Sent: Saturday, 27 January 2001 07:51
To: samba at lists.samba.org
Subject: Fw: multi user access to 1 data file
From: dkwok <dkwok at iware.com.au>
To: samba at lists.samba.org <samba at lists.samba.org>
Date: Sunday, January 21, 2001 10:01 AM
Subject: multi user access to 1 data file
I am running v2.0.7 and have set up a network drive for an accounting ledger
system. The software is called MYOB and is quite popular in Australia. This
is the first time I have to deal with multi user access to 1 data file.
My setup is:
oplocks = yes
socket options = TCP_NODELAY
socket options = IPTOS_LOWDELAY
force group = office
directory mask = 0770
browesable = yes
writable = no
readonly = no
creat mask =0770
The MYOB program is executed local at workstation and only ccess data
through the network drive. When only 1 workstation accessing the data the
performance is quite normal. However, as soon as another workstation logged
onto and accessing the same data file. The performance is not so slow that
it takes 2 minutes to record a transaction.
I have relocated the same data file into a win98 machine and all workstation
access it from that machine. The performance is then back to normal. So
either Samba is working differently when it is in multi user mode. This is
only accessing data therefore we should be talking about file locking,
transfer, read and write, etc.
Please send me any pointers or tech reference in how to resolve this issue.
More information about the samba