By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,991 Members | 1,888 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,991 IT Pros & Developers. It's quick & easy.

Using Windows Log-in in Access

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Neil Ginsberg" <ne**@nrgconsult.com> wrote in message
news:v7*****************@newsread2.news.pas.earthl ink.net...
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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
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.

"Neil Ginsberg" <ne**@nrgconsult.com> wrote in message
news:v7*****************@newsread2.news.pas.earthl ink.net...
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

Nov 13 '05 #3

P: n/a
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)

"Neil Ginsberg" <ne**@nrgconsult.com> wrote in message
news:v7*****************@newsread2.news.pas.earthl ink.net...
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

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.