how can I remove user level security that I set up

[Carolyn]

I have set up an acces database and tried to set up user-level security so
not everyone can change the data but now when I try and open it it keeps on
telling me I have no read permission or read design. All I want to do is to
be able to open it and remove this security as I don't really need it. I've
tried importing into a new database but it keeps telling me i have no
administers permission.

 

[Paul (ESI)]

Did you use the user-level security wizard? If so, it put a shortcut to the
secured database on your desktop. In order to be able to login with one of
the user name/password combos you set up, you must use this shortcut.

If you used the user-level security wizard and have decided you no longer
want security, first MAKE SURE YOU STILL HAVE THE .BAK FILE IT CREATED FOR
YOU. Once you are sure you do, rename the .bak file to a .mdb file. After
this, open it and make sure everytihng is okay. Make sure no data was lost,
corrupted, etc. Make sure there is nothing in the secured version that the
..bak file does not have unless it is something you can easily recover or
recreate.

Once you are sure the .bak file will suffice, and you've renamed it a .mdb
file, delete all of the security files involved (the secured version of the
database, the workgroup file, which is probably called "Secured," etc.). Be
aware that once you have premanently (in other words, also delete them from
the recycle bin if they go there) deleted them, you cannot get them back.
You'd have to redo the security setup if you change your mind again.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

 

[Chris Mills]

MAKE SURE YOU STILL HAVE THE .BAK FILE IT CREATED

What? In a BakPack? (sorry)

 

[Paul (ESI)]

That joke was so corny..... I LOVE IT!!!!! LOL! Yeah, I know, I'm weird. I
love corny jokes. Others may not. If they say anything about your joke, don't
worry, I got your bak. LOL! If anybody can make a cornier joke than that, I
want to see it.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

 

[Chris Mills]

For anyone not reading all threads:

Oooo! I want to go sky diving! I don't like those backpack things they give

MAKE SURE YOU STILL HAVE THE .BAK FILE IT CREATED

What? In a BakPack? (sorry)

So, here we have Paul finally educated, YOU NEED A BACKPACK!

A HA HA HEE GUFFAWW (I gotta go...)

 

[Paul (ESI)]

Well, only if you don't want to wind up flat on your bak! AHHH HA HA HA! I
could go on all day, folks. Well, okay, maybe not. I have other more
important things to do. LOL!

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

 

[Chris Mills]

That joke was so corny.....
a-maize-ing.

 

[Paul (ESI)]

a-maize-ing.

LOL! That one took me a few seconds to get. I guess my EARS were bak-ed up.
Okay, now I'm just stretching, but what can I do? I know I'm actually reading
this, not hearing it, but corn has ears, potatos have eyes. ;-)

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy