access logon

  • Thread starter Thread starter howard peteresen
  • Start date Start date
H

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.
 
Thank you. I got the code you suggested. It returns a
#Name? error. Do you know if this works with Server 2003?
 
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
 
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.
 
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
 
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!
 
Back
Top