Re: Total lockout on security question

From: Joan Wild (jwild_at_nospamtyenet.com)
Date: 06/10/04


Date: Thu, 10 Jun 2004 13:55:33 -0400

Certainly you can drop a clean copy of system.mdw, however in a properly
secured database, you wouldn't be able to then open it.

Anyway, if you have played with security and messed up the default
system.mdw workgroup, yes you can copy a clean one from another machine.

It depends on your operating system, so you could put it where it exists
now.

However, if you are totally locked out of a database that has been secured,
you won't be able to now get in.

You may have more than one mdw on your machine. That's the first step in
securing a database - create a new workgroup. You should never be modifying
the standard system.mdw. You may find the following article helpful
 http://support.microsoft.com/default.aspx?scid=kb;en-us;305542&Product=acc
and also study the security FAQ
  http://support.microsoft.com/?id=207793

-- 
Joan Wild
Microsoft Access MVP
"joe" <joe@discussions.microsoft.com> wrote in message
news:26CD686C-1331-4219-8388-5E392DD6B703@microsoft.com...
> A recent access class instructor described if a person had trouble with
security or forgotten security passwords...it could be overwritten with a
"clean copy" of the mdw file but i have forgotten if he stated  if any
version of access would work or to drop this copy on a system folder or
which folder was he was talking about.I just read a post that was more or
less on that same subject.....is it possible and what would be the correct
steps to perform this in the event of a total lockout? thanks


Relevant Pages

  • Re: Workgroup File system.mdw
    ... but you have almost certainly set up your security wrongly. ... Log in to your database, using system.mdw, as a member of the Admins ... Now create a shortcut with a target of the following form: ... when you start the secured database using the shortcut described above, ...
    (microsoft.public.access.security)
  • RE: User Level Security Malfunction
    ... The 10 Commandments of Group Level Security ... Many of the secured databases I deal with only require a database password, ... and Permissions; how to use them and how to create them. ... While you can undo or make corrections to your secured database, ...
    (microsoft.public.access.security)
  • Re: How to secure a split db?
    ... and will read the Access Security FAQ before attempting anything. ... > nutshell, you will create a custom workgroup, a new empty database secured ... The usual method of opening a secured database is via a desktop ...
    (microsoft.public.access.security)
  • Re: How secure is a secured database?
    ... from the secured database. ... That having been said, yes, there are holes in Access security. ... server-based DBMS such as SQL Server or Oracle. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: setting a password on a button on the switchboard
    ... Could you send me the sample database for the fourth option (4. ... > Security in an Access database can probably be broken down into two big ... > points about being easier than User Level Security, ... > What type of data are you trying to protect? ...
    (microsoft.public.access.forms)