How to connect to Oracle server from within microsoft access

J

James

I'm using access 2000 on Windows Me,who can tell me how to connect to the
Oracle server so that I can use the table linked to the Oracle server in
Access.
Thanks in advance.
 
A

Arvin Meyer MVP

If you have the Oracle ODBC driver, you can connect by using:

File >>> Get External Data >>> Link

You will need to change your database type to ODBC, then choose the DSN that
you've set up the ODBC connection for.
 

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 to connect to the Oracle server from Microsoft Access 1
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Connection Oracle Web Service Problem 0
Using VBA to change Crystal Reports settings from Oracle to SQL 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Access 2003 not linked to Oracle 11g 3
Open my default template when right click, select New MS Word doc within a folder 0
Installing/purchasing office 2021 plus. A licence question. 0

Top