Invalid field definition error (Error 3409)

[josieBH]

I'm trying to link to a table in an Oracle database and am getting the following error:

Invalid field definition <name> in definition of index or relationship. (Error 3409)

Is this a problem that needs to be fixed on the Oracle side or is there some setting on Access that I can use to fix this. As it stands right now, when I get that error, I have no other option but to hit OK or HELP and then the table does not get linked.

Thanks in advance for any ideas!

 

[rd65ca]

Hi

I just got the same thing. I can link to some tables but some give me this error.

If you find a solution, please post it.

 

[dhookom]

Any possibility that either of you might share your Oracle field names? I expect there is something on the Oracle side that Access can't get its head around.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[PHV]

Have some index name a leading space in oracle ? (or some illegal character)

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