Message-Id: <438F31C3.4020205@us.michelin.com>
Date: Thu, 01 Dec 2005 12:24:19 -0500
From: "Campbell, Greg" <greg.campbell@us.michelin.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.7.7) Gecko/20050414
MIME-Version: 1.0
To: Chris Moore <chrismoore@surewest.net>
CC: pgsql-odbc@postgresql.org
Subject: Re: Data showing up as #Deleted in Access
References: <20051201154138.925069DD685@postgresql.org>
In-Reply-To: <20051201154138.925069DD685@postgresql.org>
Content-Type: multipart/mixed; boundary="------------090001020906070705000801"

This is a multi-part message in MIME format.
--------------090001020906070705000801
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Access is trying to maintain an updateable recordset when you just open a table.
For an updateable table it need to be able to identify each record, in case you trying to change a value 
on the record.
So it tries to determine if there is a primary key or by matching each field, can it determine a virtual 
primary key.
If it knows the record "was/is" there but cannot determine a primary key, it says deleted -- This may not 
be exact in the detail, but seems to be the principle.


The situation is usually aided by having tables with good primary keys. If you change the indexes or keys, 
update the linked table in Access.
It is also helped sometimes by turning on row-versioning for the connection -- I usually use the ODBC 
administrator and then use Access to refresh the linked tables, or drop and re-link the tables.

If these steps do not help, post a response for more help. You can also search this mailing lists website 
archives for the "deleted" thing.


Chris Moore wrote:

> I'm trying to get ODBC working for the first time so that I can access
> a Postgres database from Access.  I'm running PostgrSQL 8.0.3, PostgreSQL
> ODBC 8.01.01.01, and Access 2003 version 11.6355.6360 SP1.  The database 
> is on a system running RedHat Linux 2.6.9-6.37-EL and the client is running
> Windows XP SP2.
> 
> When I try to open the ODBC data source in Access I see the list of tables
> correctly.  If I pick one of the tables and open it I get the correct field
> names and the correct number of rows, but every field in every row says
> "#Deleted"
> instead of having data.
> 
> Can anyone suggest what might be wrong?
> 
> Thanks,
> 
> Chris
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

--------------090001020906070705000801
Content-Type: text/x-vcard; charset=utf-8;
 name="greg.campbell.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="greg.campbell.vcf"

begin:vcard
fn:Greg Campbell
n:Campbell;Greg
org:Michelin North America - US5 Lexington;ENG-ASE
email;internet:greg.campbell@us.michelin.com
title:ASE Systems Engineer
tel;work:803-951-5561/x75561
x-mozilla-html:FALSE
version:2.1
end:vcard


--------------090001020906070705000801--