Selecting the type of security validation used when logging on to SQL Server (ADP)

1. Select the Use a specific username and password checkbox on the Connection tab of the Data Link Properties dialog box.

2. Do one of the following:

   • Clear the Allow saving of password check box to require users to log on to the SQL Server database each time they open the Access project.

   • Select the Allow saving of password check box if you want to create an application that doesn't require a user to repeatedly log in to the SQL Server database.

   Security  Avoid saving logon information when connecting to data sources. This information may be stored as plain text, and a malicious user could access the information to compromise the security of the data source.

Select the Use Windows NT Integrated Security checkbox on the Connection tab of the Data Link Properties dialog box.

You don't need to provide a password because SQL Server uses your network login identity.