samba - May 2004 - Blocking options !! I can't open the same file in two diferents clients (win98) in same time

Hi all !


I changed my win2k server last night for Mandrake 9.2 and made my shares in
Samba, and everything goes fine...

but today when we try to run our software, that access the database (data.mdb)
in Linux server, the error: the file is locked...

Only one user can open the file...

Plz, someone can help me?? I'm in trouble!

thanx

Fl?vio Henrique

It may be that an .ldb file existed when the access db file was copied 
over.  Tell everyone to close down the file then rm the .ldb file.  It 
may be something as simple as that.

Fl?vio Henrique wrote:
>Hi all !
>
>
>I changed my win2k server last night for Mandrake 9.2 and made my shares in
Samba, and everything goes fine...
>
>but today when we try to run our software, that access the database
(data.mdb) in Linux server, the error: the file is locked...
>
>Only one user can open the file...
>
>Plz, someone can help me?? I'm in trouble!
>
>thanx
>
>Fl?vio Henrique
>
>  
>

Fl?vio Henrique wrote:
> Hi all !
> 
> 
> I changed my win2k server last night for Mandrake 9.2 and made my shares in
Samba, and everything goes fine...
> 
> but today when we try to run our software, that access the database
(data.mdb) in Linux server, the error: the file is locked...
> 
> Only one user can open the file...
> 
> Plz, someone can help me?? I'm in trouble!
Someone else reported this problem a couple of months ago.

 From the list archives on 5/3/04:
tom wrote:
 > I am using Samba 2.2.8 and this fixed my problem with MS ACCESS.
 >
 > Make sure your ms access has the following options set.
 >
 > Click Tools
 >
 > Click Options
 >
 > Click General Tab and make sure the "Default Database folder"
points to
 > your Samba share
 >
 > Click "Advanced Tab" and make sure "Default Open Mode"
= shared
 >         "Default record locking" = Edited Record
 >         "Open databases using record-level locking" is checked
 >
 > In your Samba shared set the option "force create mode = 777"
 >
 > My MS ACCESS database runs like a charm now.
 >
 > Hope this helps you.
 >

Cheers

Tony

Make sure that your Samba shares have rwx on all the MSACCESS files.
Also make sure that your MS ACCESS options are set to share the files 
and do only record locking.
Look under Tools> Options > General Tab and Advanced Tab

Fl?vio Henrique wrote:
> Hi all !
> 
> 
> I changed my win2k server last night for Mandrake 9.2 and made my shares in
Samba, and everything goes fine...
> 
> but today when we try to run our software, that access the database
(data.mdb) in Linux server, the error: the file is locked...
> 
> Only one user can open the file...
> 
> Plz, someone can help me?? I'm in trouble!
> 
> thanx
> 
> Fl?vio Henrique
>