Link to Oracle with VARCHAR Primary Key problem

[nbateman]

I find that Access is unable to link to Oracle tables that have a VARCHAR2 column defined as the primary key.

All I get is the #DELETED indicators.

Anyone know how to resolve this (without changing the Oracle table).

Is it possible to link the table without selecting a Primary Key at all (I only want to report on the data, not update it).

Cheers,

Nick.

 

[PHV]

Have you tried to link to an oracle view ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[nbateman]

Good idea PH.
I'm currently working against a development database, so I can use for the moment.

Won't be able to get views set up quite so easily against the Live database though, (stable, release procedures, ownership, blah, blah) so still interested in an Access based solution if anyone has one.

Nick.

 

[cmmrfrds]

Does the varchar2 field have a limit on the Oracle side. Possibly varchar2(4000) or varchar2(255). My guess is that if it is limited to 255 it will probably work. Not all data types in Access can be made primary keys, such as, Memo, varbinary, etc.. A further guess is that the field is > 255 bytes and the OBDC driver cannot map it to a valid data type in Access that allows being made a key. Anyway, this is something to check out.

 

[CharlesCook]

Just off the top of my head...

Could you do it programmatically? Two queries and cast to the same data type. Yata Yata Yata...... Maybe a temp access table?



CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining