How to remove security

[Jennifer P]

I was playing were I should not have been. I set myself up as a user and did
not assign an admin. I have no Admin rights and the program will not let me
do anything. What do I do now remove Access and re-install?

 

[Lynn Trapp]

What do you mean you did not assign an admin? All you need to do is log on
to the database as the Admin user and you can make whatever assignments you
need or, else, just blank the Admin user's password and you won't be
prompted to log on.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Jennifer P]

Lynn when I try to log on as Admin it tells me no such user or password not
valid. I never changed any passwords for admin just created a user under my
name but forgot to give myself admin rights....

 

[Jennifer P]

Okay Lynn I did change the password figured it out....Thank you now I can
breath...

 

[Lynn Trapp]

Ah, good... I figured you must have changed the password or, otherwise, you
would not have been prompted to log on. I'm glad you can catch your breath
again.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html