Re: wrkgrp switch points to original system.mdw

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

Charlie Horse wrote:
I created a new workgroup and shortcut.

"C:\Program files\Microsoft Office\Office10\MSACCESS.EXE"
"C:\TestRWOP\Original_Data.mdb"
/wrkgrp "C:\TestRWOP\LogAttempt.mdw"

I get the message "Original_Data.mdb" not found. I click Okay
Next Messaage "...can't find file C:Documents and
Settings\Carla\Application Data\Microsoft Access|System1.mdw"

I'll assume that is a typo and should read
C:\Documents and Settings\Carla\Application Data\Microsoft
Access\System1.mdw
When it couldn't find Original_Data.mdb, all bets are off regarding the
workgroup file, so Access attempts to open using the default workgroup file,
which in your case is stored in that D and S folder.

The problem then is that it can't find c:\TestRWOP\Original_Data.mdb. Are
you certain that is the pathname? Maybe that underscore should be a space?


The System.mdw was in Docments and Settings\etc file, but I copied and
renamed it to C:\TestRWOP to practice creating workgroup files.

If you want to practice on workgroup files/setting up security, do *not*
start by copying system.mdw. You will never get a secure mdb. Step 1 is to
create a *new* mdw, and you do that using the workgroup administrator.

Backup your mdb. Then copy it. Then practice on this copy. You need to
follow a set of steps, in order. See
Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

Although the whitepaper is old, it contains information to help you
understand security.

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm

--
Joan Wild
Microsoft Access MVP


.

Relevant Pages

  • Re: wrkgrp switch points to original system.mdw
    ... I didn't follow your document of security but did Jack ... a test database. ... workgroup file, so Access attempts to open using the default workgroup file, ... renamed it to C:\TestRWOP to practice creating workgroup files. ...
    (microsoft.public.access.security)
  • Re: help with ULS
    ... the standard system.mdw workgroup file that ships with Access. ... Security FAQ ... Security Whitepaper ... Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: Creating security for MS Access application
    ... security settings seem to be done at a global level on my computer. ... You've "joined" your workgroup file on your machine, ... You've not properly secured your database if that's the case. ... with instructions on how to properly secure a ...
    (microsoft.public.access.security)
  • Re: Creating security for MS Access application
    ... security settings seem to be done at a global level on my computer. ... You've "joined" your workgroup file on your machine, ... You've not properly secured your database if that's the case. ... with instructions on how to properly secure a ...
    (microsoft.public.access.security)
  • Re: Different MDW files
    ... I not really sure, but the security wizard, and the use of a workgroup file ... In any applications that I deploy to a client environment, ... users to security groups, then in fact we NEVER assign a user to a form, ...
    (microsoft.public.access.security)