Hi all,

I'm developing a database using Ms Access 97 as the frontend and
Oracle 8.17 as the backend under win2k os. Using Oracle ODBC to link
the tables in Ms Access. This database is supposed to be used by 10
users at anyone time. Everything else is working as I expected but
one.

The one problem is, everytime I update or insert records using
SQL*Plus, the changes or the new records do not show when I open the
linked table in Ms Access frontend. I had to restart my computer
before the table in Ms Access showed the correct records/data.

Has anyone else had the same problem? Anyone knows how to overcome
this?

Regards,

Sid