Update Data (11gxe w/ sqlplus) Does Not Show in ODBC (MS Access 07)

[ianclark2992]

Hi,

I am currently working with a vey small database on my computer ran in Oracle 11gxe. I use MS Access 2007 to view and run queries with my data. I recently discovered that if I updated a column in sqlplus the data will update in my 11g database but not in MS Access. I have tried refreshing the connection and even relinking the tables with no resolve.



query I enter

Update student set first_name = 'test' where first_name = 'Ian';

student still shows as Ian in MS Access and responds to queries including first_name = 'Ian'.

student shows as test in 11g and responds to queries including first_name ='test'.


I have looked on line and have not been able to find any reason why this is happening...

Thanks in advance

[orange]

Have you tried relinking the Oracle table from Access? sqlplus will update Oracle -- it is an Oracle utility and unknown to Access.
Access talks to your oracle db via ODBC. If you updated Oracle via sqlplus, then you must relink the oracle table in Access.

Good luck.