Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Security / July 2005

Tip: Looking for answers? Try searching our database.

how can I remove user level security that I set up

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Carolyn - 29 Jul 2005 15:20 GMT
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) - 29 Jul 2005 16:31 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.