The_Duck,
your solution sounds good, but you are being too vague for my level of Access/Oracle knowledge. assume i am a novice in the DB field and give me step by step instructions please.
thanks much.

1. You should have the Oracle client installed in the system you have the Access database on.
2. Create Net8 Paths to the Oracle database you desire.
You can do this in the Net8 Configuration Asst.
3. Create a ODBC Path referring to that Net8 Path you just created
I*'m assuming you're using Windows since you're using Access.
*Find this in Control Panel/Admin Tools/Data Sources ODBC
*You can pretty much use any DSN you want since you're the only one doing this.
*Use the Oracle Driver...it's better than the MS ver. for Oracle.
4. Within your access database, goto File/Get External Data/Link Files
5. Down at the bottom find ODBC under "type of file"
6. Find the ODBC path you just created
7. Log into the Oracle database as the user that can input into the table(s) you desire.
8. Choose the table(s) you desire, this will create live links.
9. Create queries referring to your Access tables, making sure it brings up the data you want to input.
10. Finally, after you've gotten the data you want, turn these queries into "Append" queries, and refer to the similiar tables and fields you desire.

When you're sure it's all insync...trigger the append query.

hey thanks buddy (and everybody else who helped with suggestions),

that worked like a charm.

i know a little bit more about Access/Oracle now. I think it's really cool you can access other DBs from Access.