Linking Oracle View to MSAccess

  • Thread starter Thread starter Rajesh Candamourty
  • Start date Start date
R

Rajesh Candamourty

Dear All,

I have an Access Application running on a network and its a multiuser. It
works fine. One of the tables has to be updated from the master table which
resides in Oracle. My DBA Administrator has created a view and says the link
is ready for use.
My question is how do I use this link, how do I connect the Oracle View to
my MA Access table?
Any help is highly appreciated.

Thank you.
Raj.
 
1) Go to "Files | Get External Data | Link Tables" on the menu.
2) for file types at the bottom of the form choose ODBC databases()
3) Hopefully your DBA set up a File or Machine data source there for you
to select. If not you best get in contact with the DBA.

Regards
 
Back
Top