Re: How to 'commit' data from MS Access?

From: <Brad_Morgan_at_dscc.dla.mil>
Date: 2000/04/28
Message-ID: <8ecr4m$l8n$1@nnrp1.deja.com>#1/1

Make sure your Oracle table has a Primary key and then relink the table. MS Access gets confused without a true PK.

In article <8e83rb$dje$1_at_nnrp1.deja.com>, nmadson_at_my-deja.com wrote:
> I've created an ODBC link to an Oracle table which I created in
> SQL*Plus. I uploaded data using an MS Access query. I can see the
> data in the Oracle table, but when I query the table in MS Access I
get
> 778 rows that say #Deleted. (The table has 778 rows.) How do I get
> the data to display in MS Access? I would have thought that exiting
> from Access would have caused Oracle to Commit this transacation, but
> it does not appear to have done so.
>
> TIA,
> Nolan Madson
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 28 2000 - 00:00:00 CDT