Share this Page URL

Chapter 14. Understanding Access Project... > Creating SQL Server Tables in an Acc... - Pg. 515

Understanding Access Projects 5. 6. 7. 1. 2. 3. 4. 5. 6. 7. 8. Select the security method you want to use, either a trusted connection or a user name and password you designate for this database. Enter a name for the database. In the wizard's next screen, click Finish. Start Access. On the File menu, click New. In the New File task pane, click Project Using Existing Data. In the File New Database dialog box, enter a name for the project, and then click Create. In the Data Link Properties dialog box, click the Connection tab. In the Select Or Enter A Server Name text box, enter the name of your computer or select a different server. Select the security option you want to use, and then select the database you want to connect to. 515 Create a project with existing data Click the Test Connection button. If the connection is successful, you'll see a message box confirming the connection. Click OK in the message box, and then click OK in the Data Link Properties dialog box. Setting Up a SQL Server Password If an Access project file is connected to a SQL Server database (version 6.5 or later) that uses SQL Server security, you can change the login password when working in Access. (You can't change the login password for a database that is using Windows NT Integrated.) Follow these steps: 1. 2. 3. Open an Access project file or switch to the Database window for the open project. On the Tools menu, click Security, and then click Set Login Password. In the Old Password box, type the current password.