[Samba] access database locking issue

John H Terpstra jht at samba.org
Wed Mar 17 17:36:25 GMT 2004


On Wed, 17 Mar 2004, Jack Malone wrote:

> Hello. after getting suse 9.0 loaded on a new machine here an configuring
> samba 2.28 that came on the cd's I'm having a locking problem with some
> access database files. I had this same problem when i first went to linux 2
> years go an started storing some access database files on the server. It
> seems only one person  (an sometimes 2 i'm told by the users) can have the
> file open at a time. we use it for keeping up with our traffice log here of
> incoming an outgoing shippments. it was working fine on the old server but
> now that it crashed on me I had to setup a temp machine til i get some new
> parts in for the old one.

When you moved this database did you reset the lock handling settings in
MS Access?

You must launch MS Access, open Toolss->Options->General, then reset the
network path to the shared database folder. Also be sure to set the
correct parameters under the "Advanced" tab.

- John T.

>
> i will post my samba conf file in this email for someone to look at an
> point me in the direction i'm going wrong. thanks for the info / help.
>
> jack
>
> smb.conf file is below
>
>
> # smb.conf is the main Samba configuration file. You find a full commented
> # version at /usr/share/doc/packages/samba/examples/smb.conf.SuSE
> # Date: 2003-09-23
> [global]
>        socket options = SO_KEEPALIVE IPTOS_LOWDELAY TCP_NODELAY
>        domain logons = no
>        unix extensions = Yes
>        encrypt passwords = yes
>        map to guest = Bad User
>        security = user
>        preferred master = auto
>        add user script =
>        time server = Yes
>        printing = CUPS
>        veto oplock files = /*.dbf/*.fpt/*.cdx/*.mdb/*.xls
>        domain master = false
>        printcap name = CUPS
>        veto files = /*.eml/*.nws/riched20.dll/*.{*}/
>        workgroup = etlb
>        server string = BackUP production server (FROG)
>        os level = 68
>        local master = no
>        netbios name = Frog samba server
>        wins support = true
>
> [homes]
>     comment = Home Directories
>     valid users = %S
>     browseable = no
>     read only = No
>     create mask = 0640
>     directory mask = 0750
>     guest ok = no
>     printable = no
> [printers]
>     comment = All Printers
>     path = /var/tmp
>     printable = yes
>     create mask = 0600
>     browseable = no
>     guest ok = no
> [print$]
>     comment = Printer Drivers
>     path = /var/lib/samba/drivers
>     write list = @ntadmin root
>     force group = ntadmin
>     create mask = 0664
>     directory mask = 0775
>     browseable = yes
>     guest ok = no
>     printable = no
> [horizon]
>        path = /horizon
>        writeable = yes
>        comment = frog samba server
>          create mask = 0777
>        force directory mode = 777
>
>
>
> thanks again
>
>
>
>
> jack malone
> Network Administrator
> EAST TEXAS LIGHTHOUSE FOR THE BLIND
> dba HORIZON INDUSTRIES
> 903-595-3444
> http://www.horizonind.com
>
>

-- 
John H Terpstra
Email: jht at samba.org


More information about the samba mailing list