Re: secured database with Access 2002 or greater on network


babs wrote:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESSE.EXE" "F:\Access
Invoice\Active File\6-1-06.MDB" /WRKGRP "C:Documents and
Settings\Bob.KTS\Application Data\Microsoft\Access\System2.mdw"


Not exactly sure where each section begins and ends-tell me if I am
right or wrong so I can understand the path.

You have everything right.


Not sure what the /wrkgrp goes with the database or the security
file???

Using that switch tells Access to use the system2.mdw workgroup file,
instead of whatever you have set as the default in the workgroup
administrator. It only applies to this session of Access. Opening Access
any other way will use the default (which should be set to the system.mdw
that ships with Access).

Where does evertything need to be for different users on other
computers to have a secure shortcut set up - assume need path of
THEIR Access.exe on one user in Office 10- its on hard drive of
users. Path of database located on F: network drive. See security
file is presently on hard drive - where should this be- copy it or
put it on network(does the syntax/wrkgrp go with database path of
with the security file?)

Yes, you'll need to modify the shortcut so that the path to Access reflects
its location on each user's PC. The mdw file should be put on the network
in the same folder as the mdb. Then you can modify the shortcut to say...
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESSE.EXE" "F:\Access
Invoice\Active File\6-1-06.MDB" /WRKGRP "F:\Access Invoice\Active
File\System2.mdw"

Are you certain that all users have 'F:' mapped to the same location? If
so, then fine, but otherwise you can use UNC pathnames for the mdb and mdw
\\servername\path


--
Joan Wild
Microsoft Access MVP


.

Relevant Pages

  • Re: User access on a company intranet
    ... I did as you said and created a shortcut with the path you gave me and it ... I have built into my database should I disable this? ... When you want to implement security, you create a new mdw file, and follow ... to open the secure mdb is by using the mdw you created. ...
    (microsoft.public.access.security)
  • Re: Security Wizard Locked ALL Dbs
    ... Username/Password for any access database I try to open ... I just want all of this security off ... Make a shortcut to your mdb file: ... Place the cursor at the far left of the Target ...
    (microsoft.public.access.security)
  • Re: Pointing to a pointer to an .mdb
    ... shortcut to the batch file. ... Users run the shortcut, the shortcut calls ... the .bat file, the btch file runs the .mdb file, access starts and it ... current database, which is full of valid data, with a new database ...
    (microsoft.public.access.formscoding)
  • RE: Workgroup Security
    ... I am going to make an .mde out of this database. ... Did you set an Admin Password in your new mdw? ... When you launch the shortcut does it ask you to authenticate with your ... use it for that mdb. ...
    (microsoft.public.access.security)
  • RE: Workgroup Security
    ... I am going to make an .mde out of this database. ... Did you set an Admin Password in your new mdw? ... When you launch the shortcut does it ask you to authenticate with your ... use it for that mdb. ...
    (microsoft.public.access.security)
Loading