network logon

[HDI]

Hi,

We are working with Office 2003 and for our access apps we logon with
the classic access security.

The username and password is the same as windows logon. Is it possible
that access check the network logon?

Thx

[Rick Brandt]

HDI wrote:

Hi,

We are working with Office 2003 and for our access apps we logon with
the classic access security.

The username and password is the same as windows logon. Is it possible
that access check the network logon?

Thx

No.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Arno R]

"Rick Brandt" <ri*********@ho tmail.comschree f in bericht news:eW******** *********@newss vr13.news.prodi gy.com...

HDI wrote:

>Hi,

We are working with Office 2003 and for our access apps we logon with
the classic access security.

The username and password is the same as windows logon. Is it possible
that access check the network logon?

Thx

No.

No ???

I guess the OP simply needs this:
http://www.mvps.org/access/api/api0008.htm

Arno R

[Tim Marshall]

Rick Brandt wrote:

>>The username and password is the same as windows logon. Is it possible
that access check the network logon?

No.

Rick, what if the network login is the Windows profile name? I know in
our organization set up, my user profile name is the same as my network
login name. Of course, that may not be the same everywhere.

If, and only if, the above situation is true with the OP, he could use
the code in http://www.mvps.org/access/api/api0008.htm

Or have I missed the mark here?
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me

[Rick Brandt]

Arno R wrote:

"Rick Brandt" <ri*********@ho tmail.comschree f in bericht
news:eW******** *********@newss vr13.news.prodi gy.com...

>HDI wrote:

>>Hi,

We are working with Office 2003 and for our access apps we logon
with the classic access security.

The username and password is the same as windows logon. Is it
possible that access check the network logon?

Thx

No.

No ???

I guess the OP simply needs this:
http://www.mvps.org/access/api/api0008.htm

Arno R

My take was that the OP wanted Access Security to automatically use the
network credentials for logging into Access. While Access can run code to
retrieve the network logon UserName it cannot use that as the User Level
Security account. I mean unless you set up all accounts to have blank
passwords.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Terry Kreft]

You can use API to get the user logon. You cannot get the users password
(pretty stupi system if you could).

You cannot use Windows authentication to automatically log in to the access
database through Acess security.

--

Terry Kreft
"HDI" <hd***@hotmail. comwrote in message
news:11******** *************@b 28g2000cwb.goog legroups.com...

Hi,

We are working with Office 2003 and for our access apps we logon with
the classic access security.

The username and password is the same as windows logon. Is it possible
that access check the network logon?

Thx

[HDI]

You cannot use Windows authentication to automatically log in to the
access
database through Acess security.

This is what i want like sql-server.
So the answer is NO.

Terry Kreft schreef:

You can use API to get the user logon. You cannot get the users password
(pretty stupi system if you could).

You cannot use Windows authentication to automatically log in to the access
database through Acess security.

--

Terry Kreft
"HDI" <hd***@hotmail. comwrote in message
news:11******** *************@b 28g2000cwb.goog legroups.com...

Hi,

We are working with Office 2003 and for our access apps we logon with
the classic access security.

The username and password is the same as windows logon. Is it possible
that access check the network logon?

Thx

[Terry Kreft]

That's what I said <g>.

--

Terry Kreft
"HDI" <hd***@hotmail. comwrote in message
news:11******** *************@i 42g2000cwa.goog legroups.com...

>
You cannot use Windows authentication to automatically log in to the
access
database through Acess security.

This is what i want like sql-server.
So the answer is NO.

Terry Kreft schreef:

You can use API to get the user logon. You cannot get the users

password

(pretty stupi system if you could).

You cannot use Windows authentication to automatically log in to the

access

database through Acess security.

--

Terry Kreft
"HDI" <hd***@hotmail. comwrote in message
news:11******** *************@b 28g2000cwb.goog legroups.com...

Hi,
>
We are working with Office 2003 and for our access apps we logon with
the classic access security.
>
The username and password is the same as windows logon. Is it possible
that access check the network logon?
>
Thx
>

[David W. Fenton]

"HDI" <hd***@hotmail. comwrote in
news:11******** *************@i 42g2000cwa.goog legroups.com:

[Terry Kreft:]

You cannot use Windows authentication to automatically log in to
the access
database through Acess security.

This is what i want like sql-server.
So the answer is NO.

Er, you can, sort of, if you create user accounts with no passwords,
the names of which match the Windows logon.

You could also skip that and utilize the Windows logon and group
membership to control access programmaticall y within your
application.

However, it would also be useful to be able to use ActiveDirectory
organizational units, which are more likely to correspond, seems to
me, to real-world permissions (at least in the organizations I've
worked with). Unfortunately, I've never found code for doing this
that I could understand how to port to VBA.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/