Removing Security settings

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

Guest

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.
 
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 said:
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.
Click to expand...

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.
 
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?
 
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
 
Back
Top