MS Access ===> ORACLE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: MS Access ===> ORACLE

  1. #1
    Join Date
    Sep 2001
    Posts
    14
    I installed Oracle8.1.6 client and ODBC on my pc.
    Now I can connect to the Oracle database 8.1.6 and set up the linked table in MS access database. How could I update the Oracle database table from the linked table in MS access database?

    For example, there is a table name test_odbc in ORACLE DB.
    I setup a linked table link_test_odbc in the MS access DB.
    What I want to do is to update the table link_test_odbc from MS access, then test_odbc in ORACLE DB is updated.
    But when I tried to update table link_test_odbc in MS access I got the message " the recordset is not updateable".

    Any idea? Thanks.



  2. #2
    There are some Notes in Metalink but they mention ADO or Visual Basic, and the solution are:
    1.-set the 'Updateability' property to updateable
    2.-cmd.Properties("IRowsetChange") = TRUE
    3.-Rst.open "select ename,empno,job from scott.emp",con,adOpenStatic,adLockOptimistic,adcmdText

    But my first thought was on a property on the ODBC DSN itself, maybe a Read-only checkbox
    Hope it helps.

    Ramon Caballero, DBA, rcaballe@yahoo.com

  3. #3
    Join Date
    Sep 2001
    Posts
    14
    Thanks, Rcaballe. I solved the problem according to your idea.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width