Running MS Access

[Bryan O'Shea]

Andrew Perrin - Demography wrote:

> We have an access database shared, and working fine; here's the info on
> the share. Multiple users use it all the time.
>
> [global]
>   workgroup = DEMOGRAPHY
>   netbios name = POPULATION
>   smbrun = /usr/LOCAL/samba/bin/smbrun
>   lock dir = /usr/LOCAL/samba/var/locks
>   debug level = 1
>         wins support = yes
>         os level = 0
>         preferred master = no
>   domain logons = no
>   encrypt passwords = yes
>   security = domain
>   password server = boserup
>   log file = /opt/samba/log/samba.%m.log
>   load printers = no
>   hide dot files = no
>         default service = homes
>   time server = yes
>   guest account = nobody
>         case sensitive = no
>         preserve case = yes
>         short preserve case = yes
>   include = /usr/LOCAL/samba/lib/smb.conf.%m
>   include = /usr/LOCAL/samba/lib/smb.conf.%u
>
> [demogtrak]
>   guest ok = no
>   read only = no
>   browseable = yes
>   path = /home/davis/12s7/demogtrak
>   Comment = Demography Contact Information System
>
> #@davis:/home/davis/12s7>ls -lag demogtrak
> total 3658
> drwxrwxr-x   2 aperrin  rm101b        512 Apr  7 11:24 .
> drwxr-xr-x  26 root     root         1024 Mar 18 17:29 ..
> -rwxrwxr--   1 root     access     626688 Apr  2 10:54 demogdata.mdb
> -rwxrwxr--   1 aperrin  access    3211264 Apr  7 11:24 demogtrak.mdb
>
> ---------------------------------------------------------------------
> Andrew J. Perrin - aperrin at demog.berkeley.edu - NT/Unix Admin/Support
> Department of Demography    -    University of California at Berkeley
> 2232 Piedmont Avenue #2120  -    Berkeley, California, 94720-2120 USA
> http://demog.berkeley.edu/~aperrin --------------------------SEIU1199
>
> On Wed, 7 Apr 1999, Roger D. wrote:
>
> > Excuse me if this has been discussed before, but I searched the archives but
> > didn't find what I was looking for.
> >
> > I am running redhat 5.2 and samba1.9.18p10 and wish to use a mapped drive
> > for MS Access and
> > Peachtree Accounting. I assumed that MS Access did it's own file locking and
> > database management from the client jet egine database, but it doesn't seem
> > to work that way.
> >
> > If I use the default oplocks = true, then I get a file in use when I attempt
> > to connect the second client to MS Access.  If I use oplocks = false, then I
> > get no error, but.......the data is not updated unless the clients exit the
> > application.  Does NT run some type of processes that Samba does not?  I'm
> > not a programmer and don't understand the workings of OS's, but it seems to
> > me that WIN95 peer-to-peer would offer no services that Samba would'nt.
> >
> > Is there anywhere or any one that has MS access or Peachtree Accounting
> > working?  It is my understanding that Peachtree uses btrieve as it's
> > database engine.
> >
> > TIA
> >
> > Roger D.
> >
> >
> >

I am storing peachtree accounting software on a samba server also
this is what i used to get around the strange locks and so forth...
made a unix group called peach and added valid users to that group
and gave correct permissions to the unix path and added this to my smb.conf
i don't know if this a correct way to approach this but it gives everyone r/w
access to the dir
that belongs to the peachtree group

[peach]
 comment = Peachtree
 path=/home/peach
 writeable = yes
 valid users = @peach
 printable = no
 browseable = no
 force group = peach
 create mask = 0770
 force create mode = 0000
 directory mask =0770
 force directory mode = 0000


-Bryan