Running MS Access

[Andrew Perrin - Demography]

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.
> 
> 
>