[Samba] SAMBA and Microsoft Access

Freeman, Peter (ERHS) Freeman.Peter at saugov.sa.gov.au
Mon Apr 14 00:56:34 GMT 2003

>In the case of Access2000 and 2002, you will probably see 
>problems with more
>than one user accessing a database. I turn off all file locking on all
>shares containing Access databases. Everytime you open an mdb 
>file, take a
>look at the temprorary ldb file that pops up in the same 
>directory. This is
>trying to lock out all other users. I have chased this issue 
>round and round
>and this is the only solution I can come up with.

The way we got around it here was to use the force user parameter, that
way the .ldb file is created by the same user that is accessing the db,
otherwise you'll run into hassles.

(and switch off oplocks on the share as mentioned above)

More information about the samba mailing list