problem

Freeman, Peter (ERHS) Freeman.Peter at saugov.sa.gov.au
Thu Dec 13 21:10:03 GMT 2001


>this is a MS Access Problem.
>this is to prevent corruption from both users
>trying to update the file.

Not necessarily, the error is talking about file locking, 
not record locking.  We successfully run shared Access 
databases off Samba with multiple users accessing the same file
concurrently.  Access does have limitations with record locking
in comparison with the industry strength databases such as M*SQL etc

We've had similar locking problems with Foxpro databases which are
housed on Samba servers, my suggestion would be to look at
setting "oplocks = no" on that particular share, it has worked 
successfully for the Foxpro databases, tho it may cause problems
for other programs, so test it first.

Be aware that if you are running different versions of Windows 
(ie: 95 & 2000) that you may run into problems with this setting
as the locking code under Win 95 is buggy compared to Win2000 
apparently






More information about the samba mailing list