Hallo!

I have created Access 2000 project. Connection must use SQL Server (2000) authentication.
Is it possible to avoid logon window (asks password) each time I run the project?
It's important because if users know SQL Server password and username they can create odbc DSN to access SQL Server and view data that is not meant for them.

Thanks,
Raul

you can build a table that has all user names and login password.

then capture user domain login, compare it to your table and when it finds a match grab the password and pass it to the application. I do not have a procedure for passing the password but I will work on it. This is just an idea. I sure VB has specific way of doing this.

I have never worked with projects, but I have worked with SQL backends. If you set up the DSN for NT Authentication, it will take the network login and password and send it to the database and the users won't have to log into SQL.

Regards,

Beth M

you can use windows authentication and where ever domain name or password exist it give user permission based on what you have setup on the backend.

Remember that SQL must be setup to use both windows and sql authentication.

Why can't you use Windows Authentication?
It is better programming practice. More secure and easier to implement. I do not like using SQL Server authentication and I only use it if it is not a Windows box.
If you use SQL Server authentication " DO NOT " use a system dsn. This stay open to anyone who uses the machine.



Sal