Application level password protection on Access 97 database

  • Thread starter Thread starter Richard Clarke
  • Start date Start date
R

Richard Clarke

Hi

I am interested in being able to set a username / password on my
access database, so I can then set application level permissions, i.e.
only let certain applications open the database without recoding the
applications. Is this possible or is there a similar solution that
will allow certain apps to access the db without me having to recode
the applications connection routines.

I know I can create user security with usernames and passwords to
prevent users doing things to the db, but I need to prevent certain
apps from opening it and let others

Many thanks
 
Have your users join the system.mdw file that shipped with Access. Then,
create a shortcut to be used with your secure application. The target for
the shortcut should follow this general syntax:

"FullPathToMSAccess.exe" "FullPathToDatabase.mdb" /wrkgrp
"FullPathToWorkgroup.mdw"
 
Back
Top