Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert data into Oracle DB from MS Access Forms

adnanBIHMay 23 2010 — edited May 23 2010
Dear professionals,
how to insert data into table which reside in Oracle DB through MS Access forms?
We already created ODBC link, and use Oracle tables to select some data, and it works.
Unfortunately, we could only select data, but insert, delete and update are not available through MS Access form, although user has all permissions on the oracle DB (grant select, insert,update, delete on oracle_table to access_user).


driver:Microsoft ODBC for Oracle
MS Access 2003
Oracle DB 10.2

Thx in advance,
Adnan
This post has been answered by unknown-698157 on May 23 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 20 2010
Added on May 23 2010
#general-database-discussions
7 comments
2,119 views