secured database with Access 2002 or greater on network

[Guest]

I used the wizard to secure the database on one given computer. there are
three users. I set it up on someone who has full permissions to the
database. The other 2 users will only be able to add and edit DATA. I
know to get into it only from the desktop shortcut but am LOST and CONFUSED
as to how to set up shortcuts on the other two computers. Access is on the
Harddrive of each computer and currently the database is on the network so
everyone can get to it. Below is the TARGET path of the shortcut for the
computer I have set it up on.

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESSE.EXE" "F:\Access
Invoice\Active File\6-1-06.MDB" /WRKGRP "Cocuments 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.

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESSE.EXE" = Full Path to
MSACCESS.exe

"F:\Access Invoice\Active File\6-1-06.MDB" = Full Path to the database

"Cocuments and Settings\Bob.KTS\Application
Data\Microsoft\Access\System2.mdw"=Full path to the security file.


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

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?)

Please help the very confused!!!

Thanks,
Barb

 

[Joan Wild]

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESSE.EXE" "F:\Access
Invoice\Active File\6-1-06.MDB" /WRKGRP "Cocuments 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