Access Multi User not editable

  • Thread starter Thread starter Charlie Bravo
  • Start date Start date
C

Charlie Bravo

I am running a split data base where the backend is stored on a Samba server.
I have turned off all features that I can find on the server relating to
file locking etc. However, no records are editable on the second machine I
open the database from.
 
If I recall correctly, Samba servers have different security rules than
Windows servers. While the rules may be that each user is capable of
creating and writing to the locking file (.ldb or .laccdb), it may be that
they're not capable of updating locking files created by other users.

Try this test. Have User A create a text file in the folder where the
database exists. Then have User B try to update that same text file. If User
B cannot update the file, that's your problem.
 
On Thu, 1 Apr 2010 14:39:01 -0700, Charlie Bravo <Charlie
(e-mail address removed)> wrote:

In addition to what Doug said: If the back-end is on the workstation
rather than on the server, can records be updated? If not you likely
have a bad database design without primary keys.

-Tom.
Microsoft Access MVP
 
Charlie Bravo said:
I am running a split data base where the backend is stored on a Samba
server.
I have turned off all features that I can find on the server relating to
file locking etc. However, no records are editable on the second machine
I
open the database from.
Click to expand...
 
Back
Top