multiple users

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

How can I setup an Access database to allow for multiple users to use it at
the same time?

I have both Novell 5.1 servers and a Windows 2000 server. I've tried giving
access to a few users on the Novell server but if the file is already open,
the next user has to view it as read only.

Is there anyway to do this?

Thanks.
 
The users must have Read, Write, eXecute and Delete permissions on the
folder where the MDB file exists. This is because a locking file (.LDB) is
created in the folder when the first user opens the database, subsequent
users update that file, and the last user to close the database deletes the
file.
 
On the Novell server the users in question do have all of those rights.
Does it not function on Novell?
 
It's supposed to, as far as I know. Unfortunately (or fortunately!), I
haven't worked with Novell for years. Hopefully someone else will chime in.
If not, you might try reposting in microsoft.public.access.multiuser
 
are you using Access Data Projects?

Basically Microsoft bungled ADP and there is no way to suppress the
read only notice

you need a seperate copy for each person. i would reccomend copying
the ADP into their home drives.. that's a good place to start
 
are you using Access Data Projects?
Click to expand...

No, he is using novel server as mentioned in the original post, so he can't
possibility be using sql server.

I suppose there is the "remote" possibility that the user is placing adp
files on a novell server, and that a Microsoft based server also exists
here.
 
well you should format your novell box and get a sql server

mdb is a disease; but a less-damaging disease than XLS
 
and just for the record; i have used ADP in a novell environment just
fine before
 
Back
Top