Possibility of updating database...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Possibility of updating database...

  1. #1
    Join Date
    Aug 2003

    Possibility of updating database...

    Hello. I'm running Oracle 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.



    Sigh.....those were the days my friend, I thought they'd never end.
    I too remember when this place was coo.

  2. #2
    Join Date
    Nov 2001
    Planet Earth
    Just Link the necessary tables instead of import. I tried before.

    OCA,OCP,OCM,OC? (9i,10g,11i,12?,XXX)
    Title is not to be proud

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