Printable View
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
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 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
