Re: Data showing up as #Deleted in Access - Mailing list pgsql-odbc

From Zlatko Matic
Subject Re: Data showing up as #Deleted in Access
Date
Msg-id 006b01c5f727$7711d610$52bffea9@zlatkovyfkpgz6
Whole thread Raw
In response to Re: Data showing up as #Deleted in Access  ("Chris Moore" <chrismoore@surewest.net>)
List pgsql-odbc
Hello.
Just redesign your database. You need to have numeric primary key field in
every table. Don't use any other type as primary key, especially not any
kind of textual fields, because Access won't be able to refresh data
properly and you will face "#Deleted", which is very common problem with
Access/ODBC linked tables. You can find an article about "#Deleted" on
www.microsoft.com, too.
The best way to avoid "#Deleted" is to have a serial field (autonumber) as
primary key, in every table. That will solve your problem forever.

Zlatko


----- Original Message -----
From: "Chris Moore" <chrismoore@surewest.net>
To: "'Campbell, Greg'" <greg.campbell@us.michelin.com>
Cc: <pgsql-odbc@postgresql.org>
Sent: Thursday, December 01, 2005 7:40 PM
Subject: Re: [ODBC] Data showing up as #Deleted in Access


>I verified that the primary key was correct, and also turned on
> row versioning, but still got the same thing.
>
> Then I noticed that it was only one particular table that was having
> problems.  It occurred to me that this table had several fields of
> type "text", one of which had rows in which this field had close to
> a thousand characters in it.  I changed all the "text" fields to
> "varchar", making the one big one a varchar(2048).  That seems to have
> fixed the problem.
>
> By the way, I did try searching for "#Deleted", but the search engine
> tries to be helpful and also find instances of "delete", "deleting",
> etc.  There were just too many hits to be able to weed through them
> all and find the relevant ones.
>
> Thanks for your help.
>
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match


pgsql-odbc by date:

Previous
From: Ludek Finstrle
Date:
Subject: Re: Application crash after error - please help
Next
From: "Andrus"
Date:
Subject: Re: Application crash after error - please help