ODBC access link to Oracle

[bobmac-]

Hi All,
Using Access 2003 to link to Oracle I get the following message on some tables;

'Invalid field definition 'DATE_CONFIRMED' in definition of index or relationship'

Any ideas on what may hbe causing this?

 

[FoFa]

Are they all date type columns?
Typically with oracle, verifying your datatypes is first concern.

 

[bobmac-]

Yes, I beleive they are all dates. Thanks for the reply.
I haven't been able to return to this problem but now that I can I am trying out different drivers to see if I get a better result.