Using Windows Log-in in Access

  • Thread starter Thread starter Neil Ginsberg
  • Start date Start date
N

Neil Ginsberg

Is it possible to use a Windows 2000 log-in as the log-in for Access
user-level security, thus circumventing the Access prompt?

Neil
 
Here is how I propose it.

You start an non-secured intermediary database that will capture your
Windows username.

In this db, you have a table already populated with your username and a
less-than-useful password in this case. See
http://www.mvps.org/access/api/api0008.htm

You can use the hide property of this table, preventing it to be noticed
from the list of tables

From that db, you call the secured db with a dos command line with switches
/user and /pwd

Of course, the security is far from perfect, but typically very few users
have the knowledge to crack it.
 
Alternatives are,

1) use windows login name for access login (with blank password)

2) use windows profile to protect the workgroup and/or database,
and use a blank login name and password

3) use a blank login name and password, and use the windows
login name internally for your own security and audit records.

or any combination of the above.

(david)
 
Back
Top