Help - new user can't log in

[coopy]

I have a secured FE/BE that has been operating nicely, until I decided to
add another user. Now despite what I assign (identical to exisitng users),
it will not let this account in. I have given them all the same permissions
as a user who can login, but I keep getting the error saying that the
account doesn't have the necessary permissions to 'use' the [address of
file] object.

If I give this account open/run on the database, the account works fine. I
have never had to do this before, so am not sure what happened. Would
open/run database imply any other permissions, or the ability to link to my
secured objects, or am I just doing something wrong?

Help!

 

[Rick B]

You have to be able to open/run the database.

Rick B

 

[coopy]

But we never needed that permission before, in Access 97 or 2000. Is this
something new?

You have to be able to open/run the database.

Rick B

I have a secured FE/BE that has been operating nicely, until I decided to
add another user. Now despite what I assign (identical to exisitng users),
it will not let this account in. I have given them all the same permissions
as a user who can login, but I keep getting the error saying that the
account doesn't have the necessary permissions to 'use' the [address of
file] object.

If I give this account open/run on the database, the account works fine. I
have never had to do this before, so am not sure what happened. Would
open/run database imply any other permissions, or the ability to link to my
secured objects, or am I just doing something wrong?

Help!

 

['69 Camaro]

You have to be able to open/run the database.

But we never needed that permission before, in Access 97 or 2000. Is this
something new?

Not unless you've been doing all of your user-level security settings in
Access 1.0 or 1.1! (See
http://support.microsoft.com/default.aspx?scid=112121.) You need Open/Run
database permissions to use the database. How else is Jet going to open the
database file, run checks on the system tables to start the database,
organize and control the database table structure, control data inputs,
changes and deletes, as well as retrieve data sets for you, if you don't
have permission to do so?

You probably never manually assigned Open/Run permissions to individual user
accounts, but users will inherit the permissions assigned to the groups they
belong to. Jet will use the least restrictive permissions for each user, so
even if an individual user doesn't have Open/Run database permissions
assigned, merely belonging to the Users group, which has these permissions
assigned by default, will allow the user to open and run the database file.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

But we never needed that permission before, in Access 97 or 2000. Is this
something new?

You have to be able to open/run the database.

Rick B

I have a secured FE/BE that has been operating nicely, until I decided to
add another user. Now despite what I assign (identical to exisitng users),
it will not let this account in. I have given them all the same permissions
as a user who can login, but I keep getting the error saying that the
account doesn't have the necessary permissions to 'use' the [address of
file] object.

If I give this account open/run on the database, the account works

fine.
I

have never had to do this before, so am not sure what happened. Would
open/run database imply any other permissions, or the ability to link

to
my

secured objects, or am I just doing something wrong?

Help!

 

[coopy]

Thanks for the explanation - it makes more sense, and I guess in the end, I
did miss the group assignments. Thanks so much. I can always count on the
newsgroup to help out.

But we never needed that permission before, in Access 97 or 2000. Is this
something new?

Not unless you've been doing all of your user-level security settings in
Access 1.0 or 1.1! (See
http://support.microsoft.com/default.aspx?scid=112121.) You need Open/Run
database permissions to use the database. How else is Jet going to open the
database file, run checks on the system tables to start the database,
organize and control the database table structure, control data inputs,
changes and deletes, as well as retrieve data sets for you, if you don't
have permission to do so?

You probably never manually assigned Open/Run permissions to individual user
accounts, but users will inherit the permissions assigned to the groups they
belong to. Jet will use the least restrictive permissions for each user, so
even if an individual user doesn't have Open/Run database permissions
assigned, merely belonging to the Users group, which has these permissions
assigned by default, will allow the user to open and run the database file.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

But we never needed that permission before, in Access 97 or 2000. Is this
something new?

You have to be able to open/run the database.

Rick B

I have a secured FE/BE that has been operating nicely, until I

decided
to

add another user. Now despite what I assign (identical to exisitng
users),
it will not let this account in. I have given them all the same
permissions
as a user who can login, but I keep getting the error saying that the
account doesn't have the necessary permissions to 'use' the [address of
file] object.

If I give this account open/run on the database, the account works fine.
I
have never had to do this before, so am not sure what happened. Would
open/run database imply any other permissions, or the ability to

link

to

 

['69 Camaro]

You're welcome!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

Thanks for the explanation - it makes more sense, and I guess in the end, I
did miss the group assignments. Thanks so much. I can always count on the
newsgroup to help out.


message news:[email protected]...

Not unless you've been doing all of your user-level security settings in
Access 1.0 or 1.1! (See
http://support.microsoft.com/default.aspx?scid=112121.) You need Open/Run
database permissions to use the database. How else is Jet going to open the
database file, run checks on the system tables to start the database,
organize and control the database table structure, control data inputs,
changes and deletes, as well as retrieve data sets for you, if you don't
have permission to do so?

You probably never manually assigned Open/Run permissions to individual user
accounts, but users will inherit the permissions assigned to the groups they
belong to. Jet will use the least restrictive permissions for each

user,

so
even if an individual user doesn't have Open/Run database permissions
assigned, merely belonging to the Users group, which has these permissions
assigned by default, will allow the user to open and run the database file.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

But we never needed that permission before, in Access 97 or 2000. Is this
something new?
"Rick B" <Anonymous> wrote in message
You have to be able to open/run the database.

Rick B

I have a secured FE/BE that has been operating nicely, until I decided
to
add another user. Now despite what I assign (identical to exisitng
users),
it will not let this account in. I have given them all the same
permissions
as a user who can login, but I keep getting the error saying that the
account doesn't have the necessary permissions to 'use' the

[address
of

file] object.

If I give this account open/run on the database, the account works fine.
I
have never had to do this before, so am not sure what happened. Would
open/run database imply any other permissions, or the ability to

link

to
my
secured objects, or am I just doing something wrong?

Help!

 

[coopy]

What I mean to say is that we have never had to assign this permission
before. I don't understand what has changed.

 

['69 Camaro]

Nothing has changed since Access 2.0 in the user-level security model
regarding Open/Run database permissions. One doesn't have to assign
Open/Run database permissions to _any_ user account, as long as all users
are members of groups that have this permission assigned.

Your new user is not a member of any group that has this Open/Run database
permission, so you must either assign this permission to one of the groups
that this user is a member of, or you must assign this permission to the
individual user. Otherwise, the user will not be able to use your database
appplication, which is the main purpose of applying security -- to keep
unauthorized users out of the database. Unauthorized users do not have user
accounts with Open/Run database permissions assigned.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

What I mean to say is that we have never had to assign this permission
before. I don't understand what has changed.

I have a secured FE/BE that has been operating nicely, until I decided to
add another user. Now despite what I assign (identical to exisitng users),
it will not let this account in. I have given them all the same permissions
as a user who can login, but I keep getting the error saying that the
account doesn't have the necessary permissions to 'use' the [address of
file] object.

If I give this account open/run on the database, the account works fine. I
have never had to do this before, so am not sure what happened. Would
open/run database imply any other permissions, or the ability to link to my
secured objects, or am I just doing something wrong?

Help!