How do I view data from an outside database in Access?

I

imoux1

I have a database I use at work (I presume it is Oracle.. or at very least, I
access it with Oracle drivers).

I want look at the structure of this database visually through Access's
relationships function (since I can't seem to figure out how to do it through
the other clients I use - WinSQL, Toad).

How can I set up Access so that I can view this data?

Thank you.
 
A

Arvin Meyer

Try linking to the Oracle tables using an Oracle ODBC driver to create a DSN
(Data Source Name) for the database. Once linked to the table, you should
(with proper Oracle permissions) be able to see the field design of those
tables.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top