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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I use access to delete data from a linked oracle table? 10
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Access Relationships (Oracle Tables) 1
To convert from Oracle Database to Access 5
oracle sql plus - modified table column - not showing in Access 1
How do I get metadata in access database? 2
What to use when Access can't handle the volume of data? 3
Append new data from different database 1

Back
Top