File locking and sharing problems with Access

[Brown, Matthew]

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
permissions.

-Matthew Brown

-----Original Message-----
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
basis...

The workstations are running Windows 98 SE.

Any suggestions?

Here is a copy of the relevent sections of my smb.conf file:

----------------------------
[global]
        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

[usdocs]
        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.

Thanks,

Tarragon Allen