View Full Version : ODBC access link to Oracle


bobmac-
03-02-2010, 07:36 PM
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
03-04-2010, 12:27 PM
Are they all date type columns?
Typically with oracle, verifying your datatypes is first concern.

bobmac-
04-20-2010, 02:20 PM
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.