Hello. I'm running Oracle 9.2.0.1.0 on Windows 2000 Pro. A downloaded version with the "usual" installation.

I've got a small Oracle database using Microsoft Access to enter the data, view reports. I also use Access's query tool to gather data for reporting. There are only 70 records in this database.
I'm using ODBC to link Oracle and Access

I would like to know how I could enter the data through Access and have it updated in Oracle, and I would like to know how to enter data through SQLPlus and have it updated in Access.

I apologize for any incoveniences if the manner to achieve this is through ODBC, I missed it.

Thanks

Rick