Updating Oracle Table with Access 97

[Bill Wong]

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

[Paul Clement]

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)

[Bill Wong]

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