Access 2000 security - authenticate with windows 2000 server credentials

[csshx]

Hi

I have a database that currently has security in place so that users input their own usernames and passwords to access the database. The users have recently been added to a windows 2000 server and I want to be able to use their windows 2000 server logon credentials to provide them with automatic access to the database. Is there anyone out there who knows how to set this up? It is a rather urgent request if you could get back to me either on this forum or via email

chris@ctbjs.co.uk

many thanks

Chris

 

[Alias]

Hi

I have a database that currently has security in place so that users input their own usernames and passwords to access the database. The users have recently been added to a windows 2000 server and I want to be able to use their windows 2000 server logon credentials to provide them with automatic access to the database. Is there anyone out there who knows how to set this up? It is a rather urgent request if you could get back to me either on this forum or via email

chris@ctbjs.co.uk

many thanks

Chris

If you are able to capture the User Name from when the user authenticate to Windows will it assist you with your problem? By capturing their User Name from Windows, you can compare that to the list of user from the User table in your database. So only those that are in the User Table will be able to get in.