Try adding *.ldb to the veto oplocks list.
We've doing MS Access development here with Samba servers since 1998.
I've had the most reliable Access database performance with oplocks
disabled.
Platform: FreeBSD 4.9, Samba 2.2.8a
--
Glenn Scherb
Midwest Research Institute
425 Volker Boulevard
Kansas City, Missouri 64110
[EMAIL PROTECTED]
http://www.mriresearch.org
Phone: (816)360-5440
FAX: (816)753-5359
Page: (816)990-8513
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
On Behalf Of John H Terpstra
Sent: Wednesday, March 17, 2004 11:36 AM
To: Jack Malone
Cc: [EMAIL PROTECTED]
Subject: Re: [Samba] access database locking issue
On Wed, 17 Mar 2004, Jack Malone wrote:
Hello. after getting suse 9.0 loaded on a new machine here an
configuring samba 2.28 that came on the cd's I'm having a locking
problem with some access database files. I had this same
problem when
i first went to linux 2 years go an started storing some access
database files on the server. It seems only one person (an
sometimes
2 i'm told by the users) can have the file open at a time.
we use it
for keeping up with our traffice log here of incoming an outgoing
shippments. it was working fine on the old server but now that it
crashed on me I had to setup a temp machine til i get some
new parts
in for the old one.
When you moved this database did you reset the lock handling
settings in MS Access?
You must launch MS Access, open Toolss-Options-General,
then reset the network path to the shared database folder.
Also be sure to set the correct parameters under the Advanced tab.
- John T.
i will post my samba conf file in this email for someone to
look at an
point me in the direction i'm going wrong. thanks for the
info / help.
jack
smb.conf file is below
# smb.conf is the main Samba configuration file. You find a full
commented # version at
/usr/share/doc/packages/samba/examples/smb.conf.SuSE
# Date: 2003-09-23
[global]
socket options = SO_KEEPALIVE IPTOS_LOWDELAY TCP_NODELAY
domain logons = no
unix extensions = Yes
encrypt passwords = yes
map to guest = Bad User
security = user
preferred master = auto
add user script =
time server = Yes
printing = CUPS
veto oplock files = /*.dbf/*.fpt/*.cdx/*.mdb/*.xls
domain master = false
printcap name = CUPS
veto files = /*.eml/*.nws/riched20.dll/*.{*}/
workgroup = etlb
server string = BackUP production server (FROG)
os level = 68
local master = no
netbios name = Frog samba server
wins support = true
[homes]
comment = Home Directories
valid users = %S
browseable = no
read only = No
create mask = 0640
directory mask = 0750
guest ok = no
printable = no
[printers]
comment = All Printers
path = /var/tmp
printable = yes
create mask = 0600
browseable = no
guest ok = no
[print$]
comment = Printer Drivers
path = /var/lib/samba/drivers
write list = @ntadmin root
force group = ntadmin
create mask = 0664
directory mask = 0775
browseable = yes
guest ok = no
printable = no
[horizon]
path = /horizon
writeable = yes
comment = frog samba server
create mask = 0777
force directory mode = 777
thanks again
jack malone
Network Administrator
EAST TEXAS LIGHTHOUSE FOR THE BLIND
dba HORIZON INDUSTRIES
903-595-3444
http://www.horizonind.com
--
John H Terpstra
Email: [EMAIL PROTECTED]
--
To unsubscribe from this list go to the following URL and read the
instructions: http://lists.samba.org/mailman/listinfo/samba
--
To unsubscribe from this list go to the following URL and read the
instructions: http://lists.samba.org/mailman/listinfo/samba
