How

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Morgan Alsbrook - 10 Oct 2005 22:43 GMT

how do I use Multiuser? please some body tell me.

Reply to this Message

Rick B - 11 Oct 2005 13:38 GMT

This is a very vague question. There is no feature called "multiuser".
This simply refers to letting more than one person in your database. By
default, this is how an Access database is built. You should be able to let
multiple users in.

If you want them to log in and be given specific access to various items,
then you will need to implement user-level security.

If you will have more than a couple of users, then you should split your
database into a backend on a shared resource (LAN) and separate copies of
the front end on each user's machine.

Post back with a full description of your issue if you need further help.

FYI - I would never post my email address in a public newsgroup. Let the
spam begin!!

Signature

Rick B

> how do I use Multiuser? please some body tell me.

Reply to this Message

Gilberto - 14 Oct 2005 18:05 GMT

I am not sure about your answear, I probably will do the same question.

OK, detailed question will be:

I have a database on access 2000 already protected with profiles and
usernames (manualy)

I have the database on a shared folder.

I would like two computers to open the database and works with the forms.

The issue is, when somebody open it, nobody else can open it, just as
read-only and are unable to view the changes made by the othe person until he
close the database.

Is there any way to do it?

On my other company, we use access 2.0, this have an special way to install
and run this kind of options. like running the access itself from the server
and everyone can view the database and changes live.

thanks in advance
PD, sorry by my poor inglish, obviously i am not american.

//
Gilberto

> This is a very vague question. There is no feature called "multiuser".
> This simply refers to letting more than one person in your database. By
[quoted text clipped - 14 lines]
>
> > how do I use Multiuser? please some body tell me.

Reply to this Message

Rick B - 14 Oct 2005 18:11 GMT

If only one user can open the file, it typically means that your users do
not have FULL access to the actual file. Make sure they have Windows
privileges to read, write, modify and delete files in that folder.

Signature

Rick B

>I am not sure about your answear, I probably will do the same question.
>
[quoted text clipped - 45 lines]
>>
>> > how do I use Multiuser? please some body tell me.

Reply to this Message

Gilberto - 14 Oct 2005 18:22 GMT

Yes, they have it, because if the database is closed, anybody can open it and
modify it.

Somebody tld me something about workgroup administrator priviledges,
however, I am unable to find the correct information.

> If only one user can open the file, it typically means that your users do
> not have FULL access to the actual file. Make sure they have Windows
[quoted text clipped - 49 lines]
> >>
> >> > how do I use Multiuser? please some body tell me.

Reply to this Message

Rick B - 14 Oct 2005 18:35 GMT

You say they have because they can open it if no one else is in it. That
DOES NOT mean they have full privileges. Make sure they can DELETE and
MODIFY and ADD in that folder.

What is most likely happening is that one user opens the file and creates a
LDB (locking) file. the second user tries to open the database, but can't
because they do not have permission to modify that file.

Make sure your users have FULL PERMISSION on the file.

The workgroup determines what objects they can use, that is not what your
error is indicating.

Signature

Rick B

> Yes, they have it, because if the database is closed, anybody can open it
> and
[quoted text clipped - 66 lines]
>> >>
>> >> > how do I use Multiuser? please some body tell me.

Reply to this Message

Dervorin - 15 Oct 2005 09:53 GMT

It's also possible that the first person is opening the database
exclusively, preventing anyone else from opening it. If you look in the
Access help for "open" you'll find help on how to open it for shared
access.

> > Yes, they have it, because if the database is closed, anybody can open it
> > and
> > modify it.
> >
> > Somebody tld me something about workgroup administrator priviledges,
> > however, I am unable to find the correct information.

Reply to this Message

Larry Linson - 15 Oct 2005 22:47 GMT

> Yes, they have it, because if the database
> is closed, anybody can open it and
> modify it.

"Modify it", as in "make design changes"? Beginning with Access 2000, to
make design changes requires exclusive use; and, Access, smart software that
it is, may allow the user to open "shared", but if that is the only user,
will change to "exclusive use" before making the "design changes", thus
locking out any other users who try to log in.

Larry Linson
Microsoft Access MVP

Reply to this Message