Linking Oracle View to MSAccess

  • Thread starter Rajesh Candamourty
  • 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.
 
R

Rover

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
 

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

Linking Oracle View to MS Access 3
Field Values When Linking to an Oracle Table 1
Linking to Oracle 2
Linking to Oracle via ACCESS 1
Access 2007 ODBC for Oracle linked table issue 0
problem in exporting table from MSAccess to Oracle.... 3
coonnecting to Oracle Database 1
Oracle to Access 1

Top