ODBC - Changing Links
(From Test to Production)
in MS Access

1. Have the MS Office or MS Access installation CD-ROM for your PC handy if this is the first time links have been switched on a PC because the Linked Table Manager may have to be installed.

2. Start MS Access by clicking on icon in Banner folder corresponding to the database where the report is to be run.

3. Open the database that is to be switched.

4. Pull down the Tools menu, then select Database Utilities, then Linked Table Manager.

   If you receive an error message, you will probably need to install Linked Table Manager from the installation CD-ROM at this point, then begin this sequence of instructions again with the first step.

5. A screen will appear listing all linked tables. If the correct database appears after DSN=, click <Cancel> and you need go no further.

6. Click to check the box labeled Always prompt for new location.

7. Click Select All.

8. Click <OK>.

9. Select the new database to use and click <OK>.

10. When prompted, enter your Banner username and password for that database instance, and click <OK>. (Passwords may differ from one database instance to another.)

11. Click <Close>.

Original instructions provided by Steve Read.

Go to PREVIOUS document in sequence:  Using Banner-Access Databases