access logon

[howard peteresen]

I am using Access 2000 over Server 2003. I would like
Access to logon the user without a password prompt. I
would like Access to logon based on the userid and
password used to logon to the network (ie, not logon
twice). I will use the userid logged on in other queries
and cannot have them all logged in under Admin.

 

[Cheryl Fischer]

I don't know about getting the user's network login password (network admins
might get testy about that); however, you can use code found at the
following link to get the network user id and proceed from there.

http://www.mvps.org/access/api/api0008.htm

 

[howard petersen]

Thank you. I got the code you suggested. It returns a
#Name? error. Do you know if this works with Server 2003?

 

[Immanuel Sibero]

Hi

But you can't use this code without loggin on to the database first, can
you? And by that time it's too late.
What Howard is suggesting probably entails a security feature that has to be
built in to MSAccess right out of the box. Something like a choice where
you can choose between using Workgroup (MDW) file method, or Operating
System method (i.e. where user authentication is integrated with the OS)


Immanuel Sibero

 

[Cheryl Fischer]

Where exactly does it return the #Name error? How are you using/calling
the function?

As far as I know this code will work with Server 2003 but I have no machine
to test that on.

 

[howard petersen]

I'm sorry, I named the module the same as the function and
it was not sure which I was calling. I have renamed the
module and the code works fine. Thanks for all your help.

created an unbound control on a new form. I set the
control source of the unbound control to =fOSUserName().
The function is in

 

[Cheryl Fischer]

I'm sorry, I named the module the same as the function ...

and you're *never* going to do that again. <smile> Good for you for
finding it - thanks for letting us know - and best of luck with your
project!