Re: Problem with the PGSQL-ODBC driver and MS Access

["P.MO" <04mic4ht65k1nv3(at)jetable(dot)net>]

At 18:44 26/04/2006, you wrote:
>Hi,
>I have a user who has been converting some data from access to a 
>Postgresql 8.1.3 backend and we ran into
>a issue where some records would show up in Access with all the fields 
>as #deleted

I've seen this sometimes when using "timestamp": access doesn't
understand well the fractionnal part of it. You should instead use
timestamp(0). 

db=> create temp table zz ( field1   timestamp(0), field2 timestamp );
CREATE TABLE
db=> insert into zz values (now(),now());
INSERT 0 1
db=> select * from zz ;
        field1        |             field2
---------------------+----------------------------
 2006-04-26 22:44:42 | 2006-04-26 22:44:41.893001
(1 row)

----------------------------------------------------------
field1 will be understandable by access, not field2.
msaccess in that case will show "deleted" in all cells.

hopes that help .       P.