Removing Security settings

23 Oct 2005 3:30 PM

mrsr84

Inadvertently I added security and cannot add, revise or delete information
in a database. I am the person who created it- therefore should be the
administrator. I read the previous suggestions on how to remove security but
they are not working. I am using Office XP 2003.
HELP!!
I have resorted to rebuilding the database from scratch.

23 Oct 2005 3:51 PM

S Panja

Try logging on with Name Admin using the Password you defined for Admin.
Subsequently walk through Tools | Security | User and Group Accounts | Users

| User Name Admin and Clear Password.

--
***************************
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?

Show quoteHide quote

"mrsr84" wrote:

> Inadvertently I added security and cannot add, revise or delete information
> in a database. I am the person who created it- therefore should be the
> administrator. I read the previous suggestions on how to remove security but
> they are not working. I am using Office XP 2003.
> HELP!!
> I have resorted to rebuilding the database from scratch.

27 Oct 2005 2:21 PM

DavidQuaid

HI Ranja,

I am seeing something similar but my Tools menu is disabled (I posted about
this a few min ago myself) - how do I sign in as Admin - access doesn't
prompt me?

--
David

Show quoteHide quote

"S Panja" wrote:

> Try logging on with Name Admin using the Password you defined for Admin.
> Subsequently walk through Tools | Security | User and Group Accounts | Users
> | User Name Admin and Clear Password.
> --
> ***************************
> If the message was helpful to you, click Yes next to Was this post helpful
> to you?
> If the post answers your question, click Yes next to Did this post answer
> the question?
>
>
> "mrsr84" wrote:
>
> > Inadvertently I added security and cannot add, revise or delete information
> > in a database. I am the person who created it- therefore should be the
> > administrator. I read the previous suggestions on how to remove security but
> > they are not working. I am using Office XP 2003.
> > HELP!!
> > I have resorted to rebuilding the database from scratch.

28 Oct 2005 4:35 AM

TC

Depends what you mean by "as Admin". If Access is starting without
asking for a username/password, then, you are /automatically/ being
signed in as the Admin user - right now!

If, by "Admin", you mean "a person with administrative access to the
database", then, you must add a password to the Admin user. This will
cause each subsequent open of Access to prompt you for a
username/password. Then you enter the username/password of a user who
you know to have, administrative access to the database; for example,
any member of the Admins group of the workgroup file which was in
effect when the database was first created.

HTH,
TC

23 Oct 2005 4:21 PM

Rick Brandt

mrsr84 wrote:

> Inadvertently I added security and cannot add, revise or delete
> information in a database. I am the person who created it- therefore
> should be the administrator. I read the previous suggestions on how
> to remove security but they are not working. I am using Office XP
> 2003.
> HELP!!
> I have resorted to rebuilding the database from scratch.

Please clarify "...cannot add, revise or delete information...". Do you get
errors? Are your keystrokes simply ignored? Does the status bar indicate that
the data is not updateable?

It's possible that this has nothing to do with security. Security settings that
allow you to view data, but not change it are not likely to happen accidentally.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com