Access 97 Multi User Problem

[Jim]

Hello,
I have an accounting program that uses Access 97. Each user (currently 3)
has their own copy of the front end and accesses a mdb file on another
computer in a peer to peer network. Everything is fine for the 3 users, but
when I try to add another, Access blocks them from making any changes. They
are able to open file and view data though.

The rights on the mdb data file is set to allow full changes and everyone is
set up with at least power user rights. Any idea why Access is blocking new
users from making changes?
Thanks

Jim

 

[Albert D. Kallal]

Normally, what this means is that the new users don't have create rights to
that directory. (and they should also have delete rights).

Read/write ability is NOT enough here.

when the user opens the back end, ms-access creates a "temp" file in that
directory that is used for multi-user collisions. If this temp file can't be
created, then ms-access resorts to single user mode. So, while there seems
to be no rhyme, or reason that file create rights would effect multi-user
mode...it in fact does...


The other common problem is that your new users are set to open the database
in exclusive mode..and that again simply means single user mode...

so, check both of the above....

 

[DAVID]

Peer to peer network?

On some peer to peer networks, you can't have more than
a couple people connecting to a file at the same time.
It's a network limitation of non-server windows versions.

(david)