Running MS Access
Bryan O'Shea
bryan.oshea at usa-emotron.com
Thu Apr 8 20:28:08 GMT 1999
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
More information about the samba-ntdom
mailing list