[Samba] Samba and MS Access Problems

[Oliver Krehan]

Hi there,

we have a problem regarding MS Access with Samba.
We have 4 users which open a database at the same time. When one user makes 
changes to the database, the changes will not be seen on the other pcs 
until the database is closed an reopened. We made some tests with several 
samba options e.g. file locking, oplocks and strict locking, also with 
"sync after writes" but nothing helped. When we copy the database to a 
windows nt server, the problem disappears and everything works fine.

Does anyone has a proposal what problem we run into ?

Here is our smb.conf:


[global]
         debug level = 3
         dns proxy = no
         security = user
         workgroup = Edv
         server string = Samba Server ka029a
         socket options = TCP_NODELAY SO_RCVBUF=8192 SO_SNDBUF=8192
         netbios name = ka029a
         log file = /var/log/samba/log.%m
         load printers = yes
         netbios aliases = cal-serv
         printcap name = /etc/printcap
         max log size = 50


[calibration_data]
         path = /db/others/calibration_data
         hide dot files = no
         browseable = no
         writeable = yes
         create mode = 700
         directory mode = 700
         share modes = no
         map system = yes
         force group = root
         read list = cal_reader
         map hidden = yes
         valid users = cal391,cal392,cal393,cal394,
         delete readonly = yes
         locking = no
         force user = root

It was necessary to set the force user = root flag to make it possible to 
open the database from each pc at the same time. We are quite new in the 
linux and samba business so it would be great if someone could help us.

Thanks in advance

Oliver Krehan