[Samba] Samba and MS Access Problems

Tony Nichols tony at mail.applog.com
Mon Oct 7 19:04:00 GMT 2002

Make sure under tools, options the default open mode is shared ....
My problems had been op locks .... They all went away after I exported
the tables to a sql server then re-imported them as links.

T o n y

A.G. (Tony) Nichols
I.S. Manager
Appalachian Log Structures Inc.
tony at mail.applog.com 
888-999-2574 x124

-----Original Message-----
From: samba-admin at lists.samba.org [mailto:samba-admin at lists.samba.org]
On Behalf Of Oliver Krehan
Sent: Monday, October 07, 2002 10:48 AM
To: samba at lists.samba.org
Subject: [Samba] Samba and MS Access Problems

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
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
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:

         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

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

To unsubscribe from this list go to the following URL and read the
instructions:  http://lists.samba.org/mailman/listinfo/samba

More information about the samba mailing list