[Samba] MS Access and RAID

Noel Kelly nkelly at citrusnetworks.net
Mon Oct 28 09:34:00 GMT 2002

I'll let someone with more knowledge than I get into the RAID buffer
discussions but just wanted to make sure you had the same smb.conf on the
two machines?  And therefore had oplocks turned off?

A recent posting which you might have already seen:

	1.  Always run the Access database application, (Forms, code,
queries, ...) on a client workstation and have the back-end data on the
server.  The application container links to the shared tables on the server.

	2.  Oplocks = no 
	3.  Kernel Oplocks = no 
	4.  Level2 Oplocks = no 
	5.  Blocking Locks = yes 
	6.  Locking = yes 
	7.  Strict Locking = no 
	8.  Share Modes = yes

Success will be improved if you follow the pessimistic locking model for
most of your data access.  This means that the edited record is always
locked.  You should do this regardless of whether you use Windows or Samba
on your back end server.  This also applies to point number 1.

-----Original Message-----
From: Harry Mills [mailto:harry at navaho.co.uk]
Sent: 28 October 2002 08:57
To: samba at lists.samba.org
Subject: [Samba] MS Access and RAID


We have been having a few problems with a M$ Access DB held on a Samba

Samba version: samba-2.2.4-2N1

We have rebuilt a new server, and transferred the database over to the new
box, along with word/excel docs etc. Everything is working fine, except the
access database, which is running very very slowly (can be over a minute to
open a record).
Details are a little sketchy, but it would seem that when the new server is
being used, one workstation has reasonable access speeds, but subsequent
workstations are slow - although this could be a 'user diagnosis syndrome'

The access binary is held locally on the workstations.
If you transfer the database back to the old samba server, it runs fine.
The two servers are running the same version of samba, same Kernel (2.4.18).
The workstations are Windows98, doing domain logons to the Samba server.

The only difference I can see between the old and new servers, is the new
server has two raided (mirror) IDE drives, the old server is a single drive
box. There are no errors on the NICS, oplocks are off for *.mdb and *.ldb
tcpdump shosw data flowing consistently between the server and the
workstation. The Load Ave on the box is near enough 0.0.

For the moment, I have put them back on the old server.

Any help would be gratefully received - bit stumped on this one!
Harry Mills                                        DDI:01749 812100
Educational Development Manager                    Fax:01749 812749
Navaho Technologies                                Main Office: 0870 7034015

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

Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.404 / Virus Database: 228 - Release Date: 15/10/2002

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.404 / Virus Database: 228 - Release Date: 15/10/2002

More information about the samba mailing list