[Samba] MS Access and Samba

[Glenn Scherb]

I develop large laboratory databases with MS Access.  All my back end
servers are Samba 2.2.4 on FreeBSD.  The key to multi-user success lies
in these configuration points:

	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.

HTH,

Glenn


-- 
Glenn Scherb 
Midwest Research Institute 
425 Volker Boulevard 
Kansas City, Missouri  64110 

gscherb at mriresearch.org 
http://www.mriresearch.org 

Phone:  (816)753-7600 x1806 
FAX:  (816)753-5359 

Page:  (816)990-8513 
        pagegscherb at mriresearch.org 



-----Original Message-----
From: samba-admin at lists.samba.org [mailto:samba-admin at lists.samba.org]
On Behalf Of Oliver Krehan
Sent: Friday, October 18, 2002 6:56 AM
To: samba at lists.samba.org
Subject: [Samba] MS Access and Samba


Hi,

we still have some trouble running a MS Access-database on Samba. We now

tried it with v.2.2.6 on RH 7.3 but still we either get no acces on the 
database simultanously or we run in problems with updating the database.

The problem is that we make some changes on one of the clients but the 
changes are not visible to the other clients until they shut down the 
database and reopen it. We tried all lock options but there appears
always 
one of the problems described above. If we disable oplocks in any way,
only 
one client can open the db.

We also tried to update the W2K-clients to SP3 because I read something 
about problems with oplocks on W2K-SP2 but nothing helped. A Google
search 
on this problem brought up an article that MS Access has huge problems 
running on Samba or any other file-server-system than Windows.

Has anyone ever get an Access-db running on more than 2 clients 
simultaneously and if yes, could you please give us some helpfull hints
?

Thanks in advance.

Oliver

--
Oliver Krehan
IT Security Assistent

Actaris
Hardeckstrasse 2
76185 Karlsruhe, Germany
Tel:    +49 721 5981 325
Fax:    +49 721 5981 189
http://www.actaris.com



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