Application level password protection on Access 97 database

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
 
L

Lynn Trapp

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I open a secured database? 3
Secure db with one password and no user-level? 1
Error 0x80040E4D when tryng to open an password protected Access database programmatically 1
Access 97 Security Dilemma 3
Accessing password-protected databases from .Net Framework 2
2007 access to a 2003 database 1
Securing DB on a network drive 3
running a compact script, security issue 1

Top