Re-linking a table in Microsoft Access

Whenever a change is made to the Thomas College database tables that you use, you will have to re-link the table that has changed. You have to do this because the connection information that Microsoft Access uses is now different then the information that SQL Server uses, making it impossible to communicate. To relink a table, please follow the instructions below:

1. In your database, right-click on the table that you need to relink.
2. Select "delete" from the menu that appears.
3. When asked if you want to delete the table, click "Yes". This deletes the LINK the table, not the table itself. You do not need to worry about deleting the data in the database by re-linking a table.
4. You should be back at the database menu in the "Tables" section.
5. Click "New".
6. Click "Link Table", then OK.
7. In the drop-down box that says "Files of Type" (towards the bottom of this window), select "ODBC Databases ()"
8. Click on the "Machine Data Source" tab.
9. Double-click the "Admin" choice.
10. From the list that appears, click on the table that you want to link to. This will highlight the table. If you are linking to more than one table, just click on all of the tables that you want, it will select all of the tables that you click.
11. Click "OK".
12. You now have a new link to the table.