multiple user problem

M

mezzanine1974

We have a access database in a folder under server. Once first user
open the database, noone else can open database anymore! It is
happening only for that database.
What might be reason please?
 
A

Albert D. Kallal

I suspect if you placed other databases in that same directory, and try this
again, you'd get the same results.

Is likely one of two problems:

1) you have the databae setup to be open exclusive. open up the database,
and
go tools->options->advanced tab.

Make sure the option to open the database is shared, and not exclusive.

2) the user or opening that folder does not have file create rights. as a
general rule, users accessing files in that folder will need full file
creation rights, and also as a general rule deletion rights. If MS access
cannot create some temper were a working files in that directory that it
needs for multi user operation, then MS access will switch into single user
mode. as a result most people say that they have all kinds permissions set
for that particular folder, but the windows permissions must allow the
creation of files in that shared dir.

Check both of the above.

also note that as a general rule if you're going to allow a multiple users
into a database at the same time, then you really need to split your
database, this concept of splitting, is explained here:

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

Note that the above article tells you not only that you should split, but
also explains conceptually why it is a good idea to split.
 
M

mezzanine1974

Albert,

Thanks a lot. It is running properly somehow.
Item#2 was suspicious. If it will happen again, i will concentrate on
that.

I will read the article above regarding multiple users.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top