MS Access and PostgreSQL

From: "C K" <shreeseva(dot)it(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: MS Access and PostgreSQL
Date: 2006-04-07 19:45:49
Message-ID: d3561eb00604071245g52782ecasa7940170dbcd1de0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear Friends,
I am here for a problem regarding MS Access and PostgreSQL connection
through ODBC. I have liked my PostgreSQL database tables to MS Access.
When I am going for inserting/updating any data is just displays
#deleted. I also use MySQL (client's choice). Same problem occurs for
MySQL also. But when I set the 'Return matching rows' option from
MyODBC 3.51.12 interface. the problem mostly gets solved. Other things
required are PK (or Unique column), a timestamp etc. I have done all
these for POstgreSQL, but it doen't work. Is there any option as
'Return matching rows' for PGODBC? Or How I can solve this problem?
Please help.
Thanks and Regards.
CPK

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message James Herbers 2006-04-07 20:00:32 Re: MS Access and PostgreSQL
Previous Message Tom Lane 2006-04-07 18:39:31 Re: database owner gone?