Cannot access Oacle view which has changed

[Kalyanam Sankar]

Hi All
I have an oracle view which is linked to MS access thru
Oracle ODBC.Recently we changed the definiion of the view
(removed one of the columns in the view).Now whenever I
try to access this view Access gives me
"ODBC--Call Failed.Invalid column name".
The view is accessible thru SQLplus.Also If I create an
dsn with MS's oracle ODBC(instead of Oracles),I have no
problem.
Has anyone experienced this behaviour?Should I ask all
my users to use MS ODBC????
TIA
Kalyan

 

[Ed]

Have you re-linked the table?? If not, do so.

 

[Joe Fallon]

Whenever you change the underlying table/view you have to delete the link
and re-create it.