The usual way to do this is to "link" to the Oracle tables via ODBC, so that
they appear in the Access table list (with special icons, to indicate that
they are just links to the real tables).
After that, you can compose queries in Access in the usual way. If you have
some special queries or need to use Oracle functionality in your query SQL,
create a "pass-through" query in Access.
You can find more detailed info on this stuff in the Help file.
Hope this helps,
Anne
"vnl" <vn****@vnl999.invalid> wrote in message
news:Xn********************@216.196.97.131...
Where in Access are the features to run SQL queries and view tables on an
Oracle server?
Thanks.