Using Windows Log-in in Access

[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

 

[Rick Brandt]

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

No.

 

[Saintor]

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.

 

[david epsom dot com dot au]

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)