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.

Signature
Have a nice day!
~Paul
Express Scripts,
Charting the future of pharmacy
> 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.
Chris Mills - 29 Jul 2005 16:35 GMT
> MAKE SURE YOU STILL HAVE THE .BAK FILE IT CREATED
What? In a BakPack? (sorry)
Paul (ESI) - 29 Jul 2005 17:35 GMT
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.

Signature
Have a nice day!
~Paul
Express Scripts,
Charting the future of pharmacy
> > MAKE SURE YOU STILL HAVE THE .BAK FILE IT CREATED
>
> What? In a BakPack? (sorry)
Chris Mills - 29 Jul 2005 17:43 GMT
For anyone not reading all threads:
> Oooo! I want to go sky diving! I don't like those backpack things they give
"Chris" wrote (Paul wrote):
> 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) - 29 Jul 2005 18:00 GMT
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!

Signature
Have a nice day!
~Paul
Express Scripts,
Charting the future of pharmacy
> For anyone not reading all threads:
>
[quoted text clipped - 7 lines]
>
> A HA HA HEE GUFFAWW (I gotta go...)
Chris Mills - 29 Jul 2005 18:04 GMT
> That joke was so corny.....
a-maize-ing.
Paul (ESI) - 29 Jul 2005 18:21 GMT
> 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. ;-)

Signature
Have a nice day!
~Paul
Express Scripts,
Charting the future of pharmacy