Data Warehouse Frequently Asked Questions
To add a new SQL table within an Access database, follow these steps:
-
On the File menu select Get External Data and
then Link Tables....
-
On the bottom of the Link dialog box, select Files of Type: ODBC Databases ()
on the pull-down menu.
-
On the Select Data Source menu select the tab Machine Data Source.
-
Highlight the appropriate Machine Data Source (ADM, GRD, SIS, HRS,
SAM, or others) that contains the table(s) you wish to link and press OK.
-
On the Link Tables menu select (highlight) the new table(s) you
want to add and press OK.
-
If the Select Unique Record Identifier menu opens, highlight the
appropriate fields to denote a unique record and press OK. It is
important to identify the table's unique key to maintain querying efficiency. If you
do not know a table's unique key, please contact an Enterprise Applications
representative.
-
The new table(s) should now be added to your Access database.
Use this procedure to refresh the table links when the structure of a linked table has changed.
-
Open the database that contains links to tables.
-
On the Tools menu, point to Database Utilities,
and then click Linked Table Manager.
-
Select the check box for the tables whose links you want to refresh.
-
Click OK to refresh the links.
Microsoft Access confirms a successful refresh or, if the table was not found, displays the
Select New Location of table_name dialog box in which you can specifiy
the table's new location.
Data Connection from Access
The Data Warehouse
database servers are behind the University's firewall. This protects the
data and machines from intruders and hackers, which is absolutely
essential. Unfortunately, it also means we can not access the servers
from outside the campus.
|
