Field Values When Linking to an Oracle Table

G

Guest

I have successfully established an OBDC connection to an oracle database
using the driver titled Microsoft OBDC for Oracle found in the System DSN
tab. I can establish the link in Access 2003 but cannot view the table
contents.

When I link to the Oracle table in Access, the oracle field names show
correctly, but all the field values show as #name$. Then I am immediately
prompted to reenter my ID and password. I know I am entering the correct ID
and password.

Any suggestions are appreciated.
 

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 to Oracle via ACCESS 1
Linking Access and Oracle Database 2
Access 2007 ODBC for Oracle linked table issue 0
Insert Record into Oracle Table 1
Access Oracle ODBC 2
Oracle to Access 1
Import from Web-Based Database; Oracle 1
coonnecting to Oracle Database 1

Top