Re: Using Windows Authentication

While I agree with Rick that this probably shouldn't be necessary, Randy
Birch has code to use the NT Challenge procedure to validate a user at
http://vbnet.mvps.org/code/network/acceptsecuritycontext.htm

(Obligatory warning: Randy's site is aimed at VB programmers. There are
significant differences between the controls available for us on forms in VB
and in Access. Because of this, many of his samples will not port directly
to Access. Looking quickly at this particular example, though, I think you
should be okay)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Radtherapy" <Radtherapy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3A4D6D5E-2D5F-49EC-8EC0-5458987B7BC8@xxxxxxxxxxxxxxxx
BTW - Thanks for responding Rick.

What I want to accomplish is a way to have my user enter a user name and
password and then verify that account through AD.

After that, I can programmatically control their permissions.

"Rick Brandt" wrote:

Radtherapy wrote:
This is probably pretty simple, but I've spent too much time trying
to figure it out on my own.

I'm using Access 2007, SQL Server 2005 (Windows Authent), Windows
Server 2003.

Multiple users share computers, so I need to create a login feature in
Access that will verify the users through their Windows account. If
the authentication fails, I need to deny them access to the database
- and they need to NOT be able to bypass the login (i.e. hold shift
key to open db).

SQL is set up for Windows Authentication because my users already
have 3 different accounts they have to manage passwords for - I'd
hate to give them one more.

Thanks for any help,

BA

Access cannot use Windows authentication, but if you are using that for
permissions on the server tables then that should be all you need.
Non-authorized users will be able to open the Access file, but if they
have
no permissions on the server all they will get is errors.

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





.

Relevant Pages

  • Re: Using Windows Authentication
    ... Doug Steele, Microsoft Access MVP ... I can programmatically control their permissions. ... I'm using Access 2007, SQL Server 2005, Windows ... SQL is set up for Windows Authentication because my users already ...
    (microsoft.public.access.security)
  • Re: Using Windows Authentication
    ... I'm using Access 2007, SQL Server 2005, Windows ... SQL is set up for Windows Authentication because my users already ... permissions on the server tables then that should be all you need. ...
    (microsoft.public.access.security)
  • Re: Very Urgent
    ... Ohh yes we are using SQL Server which is running in the production server ... then you might want to check the permissions of the user connecting. ... > Verify if you are using Windows authentication. ... > where the log file is located has no permission issues. ...
    (microsoft.public.sqlserver.clients)
  • Re: FC3 Security
    ... > relevant if the machine is server or not. ... > sharing is commonly used on the university type of network). ... > as long as Rick is not bugging them to troubleshoot his problems. ... I would ask for a security audit of the data center so any weaknesses ...
    (Fedora)
  • Re: A little router and modem advice , please.
    ... as business goes, it might be something to think about.. ... router and in addition to what the current cable modem router will do ... but that's definitely something Rick would have to hire ... own web server, he's not running his own mail server, he sure as f*ck ...
    (rec.games.pinball)