multiple users

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

 

[Douglas J. Steele]

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.

 

[Glenn]

On the Novell server the users in question do have all of those rights.
Does it not function on Novell?

 

[Douglas J. Steele]

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

 

[Albert D.Kallal]

On the Novell server the users in question do have all of those rights.
Does it not function on Novell?

It should work. As mentioned, users need full rights, and that means create,
and delete rights. (full rights = full rights).

You should split the software application however. You can read about that
here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[dbahooker]

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

 

[Albert D.Kallal]

are you using Access Data Projects?

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.

 

[aaron.kempf]

well you should format your novell box and get a sql server

mdb is a disease; but a less-damaging disease than XLS

 

[aaron.kempf]

and just for the record; i have used ADP in a novell environment just
fine before