Access 2000 and PostgreSQL 6.5 - Mailing list pgsql-interfaces

From Phil Davey
Subject Access 2000 and PostgreSQL 6.5
Date
Msg-id Pine.SGI.3.96.1000825113737.3963347D-100000@mole.bio.cam.ac.uk
Whole thread Raw
List pgsql-interfaces
Hello,

This is my first post to this list, so I hope it's right.

I'm trying to get Access 2000 to use a database on a linux PostgreSQL box.
The database works fine, as I can use a different program on a different
machine to select and update records etc.

Access (using linked tables) will view the database fine, but it gives a
'write conflict' message whenever I try and update a record.

I've tried making a MSysConf table which made no difference. 
I've unset the readonly tick boxes in the ODBC driver settings.
The pg_hba.conf file is set up correctly.
I've also found some info in the microsoft knowledgebase (Q225926) which
seems to describe the problem exactly, but none of the solutions seem to
work.

What am I missing?

Thanks for any help.
-- 
Phil Davey 
http://www.pod-designs.net/philandjo.html 
E-mail pod@pod-designs.net                          ICQ 46295740
Just because you're smart, doesn't mean you can't act stupid....



pgsql-interfaces by date:

Previous
From: Cedar Cox
Date:
Subject: Re: JDBC problem
Next
From: Manika dey
Date:
Subject: RE: using large objects with jdbc