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
