Linking to Oracle: Too Many Indexes

C

Craig Nestel

I'm attempting to link to an Oracle table and getting "Too
Many Indexes" error message. Is there a workaround?
 
P

Pat Hartman

-----Original Message-----
I'm attempting to link to an Oracle table and getting "Too
Many Indexes" error message. Is there a workaround?
.
I'm going to take a guess -
Click to expand...
1. Define a view
2. Link to the view
3. Since Access won't see the primary key, you'll need to
specify the unique index as you link the table or it will
not be updatable.
 

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

Can't get real oracle error with Access error 3155 0
Linking Access and Oracle Database 2
oracle fields exceed 255 3
too many indexes 1
Access 2007 ODBC for Oracle linked table issue 0
Error: Cannot add MS ODBC for Oracle 1
Linking to Oracle: Too Many Indexes Error Received 2
Field Values When Linking to an Oracle Table 1

Top