RE: how can I remove user level security that I set up

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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


"Carolyn" wrote:

> 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.
.

Relevant Pages

  • Re: How to remove password dialog?
    ... I'd like to have no security setting at ... Backup your secure database ... >then open that bak file you renamed. ...
    (microsoft.public.access.security)
  • Re: Microsoft has utterly failed with Access 2007
    ... I can't answer on Microsoft's behalf, but Access User-Level Security really ... Any idea why MS did away with user-level permissions? ... our database from Access 2003. ...
    (microsoft.public.access.modulesdaovba)
  • Re: RWOP queries for back-end secuirty: easy/hard? slow/fast?
    ... user-level security that prevents viewing/importing of data by ... Jet user-level security that are left out of all the documentation ... from creating a new database while logged in with a specific mdw. ... can't create a new database while joined to your secure mdw then ...
    (comp.databases.ms-access)
  • Re: How to remove password dialog?
    ... you used the security wizard to secure your database. ... and then rename the bak file to have a mdb extension. ... and the secured mdw. ...
    (microsoft.public.access.security)
  • Re: Access 2007 Security
    ... Microsoft's new ACCDB format basically means that I would have to port all ... security system using tables of names and groups as well as security, ... "Since JET is a file based database system where users need ... the file format is converted to ACE format, User-Level Security ...
    (microsoft.public.access.security)