File locking and sharing problems with Access
MBrown at msdemo.ms.gmsmail.com
Wed Jul 12 13:27:01 GMT 2000
Isn't this a 'share modes' issue?
I had the same problem, but I remember fixing it with a simple setting. I
think it was share modes = yes, but I cannot recall at this specific moment.
I guess I could conceive of it being a problem of the create mask as well.
Perhaps the .LDB file created to lock the database is being masked as 0700
or something like that, effectively locking out any other users but the user
who first opens the file (thus creating the owner-locked version of the
..LDB). TO check this one, open the access db then do a ls -l on the
directory with the access db, looking for the .LDB file. Look at its
From: Tarragon Allen [mailto:tarragon at infoxchange.net.au]
Sent: Wednesday, July 12, 2000 2:08 AM
To: Multiple recipients of list SAMBA-NTDOM
Subject: File locking and sharing problems with Access
I have a linux server running Samba 2.0.6, and I have a share on the server
which holds an access database that several people have to access
simultaneously. I had the database hosted on another machine (Windows 98)
with no hassles, however after I moved it to a shared drive on the Samba
server, it returns with this error 'Couldn't use "//TALOS/USDOCS/User
Database.mdb", file already in use' from Access 97, or 'Could not lock file'
from Access 2000, whenever a second person tries to open the file.
However (and I've only just noticed this feature) if I log into one
workstation with my samba username/password, open the database, then go to
another machine, log in as myself, I can open the database multiple times
with no problems. This makes me think that the locks are set on a per user
The workstations are running Windows 98 SE.
Here is a copy of the relevent sections of my smb.conf file:
workgroup = IX
netbios name = TALOS
security = user
invalid users = root bin daemon adm sync shutdown halt mail news
uucp operator games gopher ftp lp squid
wins support = yes
domain master = yes
preferred master = yes
os level = 34
map to guest = Bad User
guest account = guest
comment = User Support Document Repository
path = /home/samba/shares/usdocs
public = no
writeable = no
read list = @usteam
write list = @usteam
usteam is a unix group containing four members of our support team.
More information about the samba-ntdom