Re: Return Settings to System.mdw

Tech-Archive recommends: Fix windows errors by optimizing your registry

You have never had to do this if using a desktop shortcut. If you changed your default to secured.mdw, then yes you would have to change it back.

--
Joan Wild
Microsoft Access MVP
"Olduke" <Olduke@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:0279F026-BB83-4CE3-A983-0A3395652CAA@xxxxxxxxxxxxxxxx
My fault for being unclear.
In the old days of Access, you had to manually tell the system to go back to
system.mdw after you closed the secured.mdw. This has not been necessary for
Access 2000 and later versions.
Sorry, it was force of habit.

"Joan Wild" wrote:

You have it right.

--
Joan Wild
Microsoft Access MVP
"webunit" <webunit@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:D6AADACF-7586-4876-B14A-28670385ED2A@xxxxxxxxxxxxxxxx
Yes, I've done everything written in your reply. I just thought that maybe
there was something additional I had to do since the instruction is to
"...return the settings to system.mdw when the user logs off." Now that I
think of it, correct me if i'm wrong, use of a shortcut with the /wrkgrp
switch does this automatically.

"Joan Wild" wrote:

Access always uses some mdw file. It ships with one named system.mdw and uses that for all sessions.

When you secure a mdb, you create a new mdw to use with it. You leave the 'system.mdw' alone so that it can be used with all unsecured databases. You use your new secure.mdw to use with your secure mdb.

Leave the system.mdw set as your default mdw (done via Tools, Security, Workgroup administrator)

Create a desktop shortcut to use for your secure mdb. The shortcut uses the /wrkgrp switch to over-ride the default (system.mdw) and use your secure mdw for that session of Access. The target would look like
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure.mdw"

Any other session of Access will use the standard system.mdw (no login), while the session started with the shortcut will use your secure mdw.

--
Joan Wild
Microsoft Access MVP
"webunit" <webunit@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:438E3014-2179-43A1-B40F-CCF71FF7703E@xxxxxxxxxxxxxxxx
I've read the excellent post by Olduke many times that explains about the
need to set up a mdw file named differently from system.mdw. However I've
never quite understood the last line of the post that reads:

"Don't forget to return the settings to System.mdw when the user logs off."

What does this mean and how is it done?

Thanks.


.

Relevant Pages

  • Re: More security questions
    ... I have an MDB file that I secured a few weeks back which was working fine. ... I have an MDW file of the same name as the MDB, ... Use a desktop shortcut to launch your secure mdb. ...
    (microsoft.public.access.security)
  • Re: Wizard not creating shortcut (Joan Wild please)
    ... I assume that you have split the mdb and the secure mdw and the backend will reside in the sharproj folder. ... When I followed your steps and put the mdw file on my C drive, the shortcut ...
    (microsoft.public.access.security)
  • Re: Return Settings to System.mdw
    ... When you secure a mdb, you create a new mdw to use with it. ... Create a desktop shortcut to use for your secure mdb. ... Any other session of Access will use the standard system.mdw, while the session started with the shortcut will use your secure mdw. ...
    (microsoft.public.access.security)
  • Re: More security questions
    ... I have an MDB file that I secured a few weeks back which was working fine. ... I have an MDW file of the same name as the MDB, ... Use a desktop shortcut to launch your secure mdb. ... When you launch via the shortcut, you should get a login prompt. ...
    (microsoft.public.access.security)
  • Re: Got it
    ... you'll set your secure mdw to be the default. ... for username/password for all sessions of Access, not just your secure mdb. ... Microsoft Access MVP ...
    (microsoft.public.access.security)