I have been away from Access for awhile so I apologize in advance if I sound like a newbie
or posted this in the wrong area and I am counting on you to set me straight if I am wrong...
I am trying to pull some data from a couple of Oracle tables and the Oracle admin has set up
an account for me and wrote an Oracle query to pull the data with an OBIEE connection,
but I would rather put together a query in Access to pull and manage this data.
The problem that I am having is that when I go to create a linked table with the
external ODBC database and log into the Oracle client with my user name and password
(which works with the OBIEE connection), one of the main tables does not appear in the link tables
window.
Is this a problem with Access or the way that the administrator set up the account tables that
I am attempting to connect with in Access?
I can see other linked tables but also need one table that is not being displayed in my link tables window.
I am using Microsoft Access 14.0.7162,.5000 (32-bit)
Thanks
or posted this in the wrong area and I am counting on you to set me straight if I am wrong...
I am trying to pull some data from a couple of Oracle tables and the Oracle admin has set up
an account for me and wrote an Oracle query to pull the data with an OBIEE connection,
but I would rather put together a query in Access to pull and manage this data.
The problem that I am having is that when I go to create a linked table with the
external ODBC database and log into the Oracle client with my user name and password
(which works with the OBIEE connection), one of the main tables does not appear in the link tables
window.
Is this a problem with Access or the way that the administrator set up the account tables that
I am attempting to connect with in Access?
I can see other linked tables but also need one table that is not being displayed in my link tables window.
I am using Microsoft Access 14.0.7162,.5000 (32-bit)
Thanks