LDAP: Access Frontend and SQL Server Backend

[Can]

I want to set up LDAP Integration for authentication but I have no idea where
to start. It will be for several databases with a MS Access Frontend and SQL
Server Backend. None of the security features in MS Access are being used,
all the security is done on the SQL server.

Presently I have a MS Access form pop up when the database is opened, you
need to type in a username and password for the SQL server to continue, you
can also change the user's SQL server password. It works great and does what
it's suppose to do.

I need to set up the LDAP Integration for authentication so that the user's
sql server password is the same as their novell login, etc. When a user
opens a database I want a login pop-up screen to appear. I have no idea
where to begin.

Any thoughts?

Candace

 

[jl5000]

Use the windows authentication mode in your SQL server (check the SQL Help
-Books Online for more details, not the Access help), your users will be
authenticated the moment they login to the network and as soon as they open
your access front end, only the rights granted inside SQL server will be
effective for that user

 

[Can]

What if I wanted them to have to use the same username and password for the
SQL server and network BUT also
1) be prompted for the username / password when they go into the database
2) have a time out for the database