There are a couple of ways to tie a SQL-Server to access.
1. create a ODBC, system DSN to SQL Server
Contral panel, either a icon will say ODBC or data sources or double click on administrative tools, then double click ODBC
2. CLick on the System DSN, click on ADD button
3. cycle to the bottom of the list to SQL Server.
4. CLick on SQL Server and click on the finish button
5. Type in any name you and click the down arrow on the server box. this will show a list of any SQL Servers that is on your network.
6. depending on the setup of teh security on SQL, you will use either of the radio buttons
7. Click next after you fill out the security information
8. set the default databse
9. Click next then finish
Open Access
1. create a new database, on the tables section right click on click on the link table
2. for the file type use ODBC Databases, click the Machine Data Source Tab and click on the name you type into the ODBC box.
3. CLick OK and you are connect to the SQL Server