how do you add or change Permissions in a DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am very new to Access 2003 (for that matter to DB's Period). Any way I
have inherited this DB and now a user is having a problem with accessing all
the things she was able to access just this morning. When she double clicks
on the DB she needs to open, it usually prompts her for her login and
password. She does not get prompted for it but it goes right into the DB and
she can go to where she needs to go to, however when she clicks on "Add New
PPT" it tells her that she does "not have permission to access the
Documention functions. Please use the "find a Document" button above."

I can logon to her workstation as the administrator and than double click
the DB and I get asked for a log in and password and I can do what ever she
needs to be done.

I dont' know why all of a sudden she is having this problem. Nothing has
changed. no updates to MS was performed or nothing added to her workstation,
nothing deleted, it is all too weird.

My question is where and how do i check and change for permissions. i asked
the person who took I took this job over from a while back how to set
permissions however, the response i got was there is a block of code behind
one of the forms that is used to grant Documentation write access. it's a
block with user names. that i have to find it and change one of the names.
all well and good, but i don't know where to look to find it. Can anyone
help me out here. I looked through the Access help but i guess i am not
putting in the rigth search words. Much appreciated in advance.
 
mdb security is crap disable it and upsize your important data to SQL
Server.

i reccomend using Access Data Projects.
 
here what I know about the DB.
users can get into the db with out a password. however there is one user
that needs to have a password because she can do things that other users can
not do.
some how (and I can not explain it) when she logs in the log in screen for
that DB is gone for her. she says that she can go in and do her thing
now--she found a work around. Other users get the log on screen however they
do not have to put a password in. they can go in and i am assuming do
queries and can not make any changes.
what do i need to do to get the log on screen for this user to come back?
 
luv2bike2 said:
I am very new to Access 2003 (for that matter to DB's Period). Any
way I have inherited this DB and now a user is having a problem with
accessing all the things she was able to access just this morning.
When she double clicks on the DB she needs to open, it usually
prompts her for her login and password. She does not get prompted
for it but it goes right into the DB and she can go to where she
needs to go to, however when she clicks on "Add New PPT" it tells her
that she does "not have permission to access the Documention
functions. Please use the "find a Document" button above."

I can logon to her workstation as the administrator and than double
click the DB and I get asked for a log in and password and I can do
what ever she needs to be done.

I dont' know why all of a sudden she is having this problem. Nothing
has changed. no updates to MS was performed or nothing added to her
workstation, nothing deleted, it is all too weird.

My question is where and how do i check and change for permissions.
i asked the person who took I took this job over from a while back
how to set permissions however, the response i got was there is a
block of code behind one of the forms that is used to grant
Documentation write access. it's a block with user names. that i
have to find it and change one of the names. all well and good, but i
don't know where to look to find it. Can anyone help me out here. I
looked through the Access help but i guess i am not putting in the
rigth search words. Much appreciated in advance.
Click to expand...

Take a look at the properties of an icon on another's computer to see
what the string is to the workgroup file. Fixing the one on the machine
that is having problems should take care of it.

In the mean time you should do some reading on the complex subject of
Access Security. You also need to make sure you have the administer access
to the database to make changes

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.
 
Thank you very much for your input. I found the workgroup and made the
change on the users system and now i will read up Access Security and set the
security settings for this users. this was of great help! :)
--
Thank you,



Joseph Meehan said:
luv2bike2 said:
I am very new to Access 2003 (for that matter to DB's Period). Any
way I have inherited this DB and now a user is having a problem with
accessing all the things she was able to access just this morning.
When she double clicks on the DB she needs to open, it usually
prompts her for her login and password. She does not get prompted
for it but it goes right into the DB and she can go to where she
needs to go to, however when she clicks on "Add New PPT" it tells her
that she does "not have permission to access the Documention
functions. Please use the "find a Document" button above."

I can logon to her workstation as the administrator and than double
click the DB and I get asked for a log in and password and I can do
what ever she needs to be done.

I dont' know why all of a sudden she is having this problem. Nothing
has changed. no updates to MS was performed or nothing added to her
workstation, nothing deleted, it is all too weird.

My question is where and how do i check and change for permissions.
i asked the person who took I took this job over from a while back
how to set permissions however, the response i got was there is a
block of code behind one of the forms that is used to grant
Documentation write access. it's a block with user names. that i
have to find it and change one of the names. all well and good, but i
don't know where to look to find it. Can anyone help me out here. I
looked through the Access help but i guess i am not putting in the
rigth search words. Much appreciated in advance.
Click to expand...

Take a look at the properties of an icon on another's computer to see
what the string is to the workgroup file. Fixing the one on the machine
that is having problems should take care of it.

In the mean time you should do some reading on the complex subject of
Access Security. You also need to make sure you have the administer access
to the database to make changes

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.
Click to expand...
 
Back
Top