Choose File, Connection, to open the Data Link Properties dialog.

Open the Select Server or Enter a Server Name drop-down list and select the NetBIOS name of the server (see Figure 20.43). If the server doesn’t appear in the list, type its name in the list’s text box.

Figure 20.43. All instances of SQL Server on machines running Windows 2000 or NT appear in the server name list. On a client running Windows 98/Me, you must type the NetBIOS name of the server.

If you’re connecting with Access 2000 or 2002 from a machine running Windows 98/Me, select Use a Specific User Name and Password to connect to the server, and type the logon ID (sa, unless you’ve added SQL Server accounts) and password, if the account is secured. Otherwise, accept the default Use Windows NT Integrated Security option.

Select the database name, and click Test Connection.

Click OK to connect to the remote SQL Server database.