[Samba] SAMBA and Microsoft Access

[Jim Wharton]

In the case of Access2000 and 2002, you will probably see problems with more
than one user accessing a database. I turn off all file locking on all
shares containing Access databases. Everytime you open an mdb file, take a
look at the temprorary ldb file that pops up in the same directory. This is
trying to lock out all other users. I have chased this issue round and round
and this is the only solution I can come up with.

On another note you may want to dump your tables into postgresql and use
linked tables in your access database/application. This is one way around
the problem. Access was never meant to be a shared database management
system.

Jim
----- Original Message -----
From: "richard" <rcoates at bigpond.net.au>
To: "Jim Wharton" <creole3 at bellsouth.net>
Cc: <samba at lists.samba.org>
Sent: Saturday, April 12, 2003 12:54 AM
Subject: Re: [Samba] SAMBA and Microsoft Access


> Jim is this a "just in case" setting? Reason I ask we've used samba for
> several years with no probs on "basic" settings! (2 small offices 6-8
> pcs each, msaccess, off2k). Every time I read about oplocks I cross my
> fingers....but nothing (with samba) has gone wrong so far!!
> Richard Coates.
>
> On Sat, 2003-04-12 at 12:44, Jim Wharton wrote:
> > turn off oplocks for any share that holds the MDB files.
> >
> > Jim
> >
> > ----- Original Message -----
> > From: "Jon Robertson" <jonrobertson at sbcglobal.net>
> > To: <samba at lists.samba.org>
> > Sent: Thursday, April 10, 2003 5:43 PM
> > Subject: [Samba] SAMBA and Microsoft Access
> >
> >
> > > I'm trying to use Access 2002 on a Samba server.....question, are
there
> > > special Samba parameters that need to be set so that  3-5 users can
enter
> > > data?  All users have proper access (no pun intended) to the SAMBA
> > > server.....
> > >
> > > thanks
> > > jr
> > >
> > >
> > >
> > > --
> > > To unsubscribe from this list go to the following URL and read the
> > > instructions:  http://lists.samba.org/mailman/listinfo/samba
>