Updating Oracle Table with Access 97


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Updating Oracle Table with Access 97

  1. #1
    Bill Wong Guest

    Updating Oracle Table with Access 97


    i created a table in oracle the i linked the table to an access database with
    odbc. i was able to insert rows into the table from access. i entered the
    data and exited out. when i reopen the table, all data elements in the table
    showed '#Deleted'. the data is stored in oracle correctly. this anomaly
    occurs when the data is displayed in access.


    can anyone help?

    bill wong

    wong@csd.com


  2. #2
    Paul Clement Guest

    Re: Updating Oracle Table with Access 97

    On 12 Jun 2002 15:05:23 -0800, "Bill Wong" <wong@csd.com> wrote:


    i created a table in oracle the i linked the table to an access database with
    odbc. i was able to insert rows into the table from access. i entered the
    data and exited out. when i reopen the table, all data elements in the table
    showed '#Deleted'. the data is stored in oracle correctly. this anomaly
    occurs when the data is displayed in access.


    See the following:

    ACC: "#Deleted" Errors with Linked ODBC Tables
    http://support.microsoft.com/directo...EN-US;Q128809&


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

  3. #3
    Bill Wong Guest

    Re: Updating Oracle Table with Access 97


    Paul Clement <UseAdddressAtEndofMessage@swspectrum.com> wrote:
    >On 12 Jun 2002 15:05:23 -0800, "Bill Wong" <wong@csd.com> wrote:
    >
    >
    > i created a table in oracle the i linked the table to an access database

    with
    > odbc. i was able to insert rows into the table from access. i entered

    the
    > data and exited out. when i reopen the table, all data elements in the

    table
    > showed '#Deleted'. the data is stored in oracle correctly. this anomaly
    > occurs when the data is displayed in access.
    >
    >
    >See the following:
    >
    >ACC: "#Deleted" Errors with Linked ODBC Tables
    >http://support.microsoft.com/directo...EN-US;Q128809&
    >
    >
    >Paul ~~~ pclement@ameritech.net
    >Microsoft MVP (Visual Basic)


    Paul,

    Thanks for your help.


    Bill


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center