From: James Herbers <james@herbers.ca>
To: C K <shreeseva.it@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: MS Access and PostgreSQL
Date: Fri, 07 Apr 2006 14:00:32 -0600
Message-ID: <4436C4E0.9010205@herbers.ca> (raw)
In-Reply-To: <d3561eb00604071245g52782ecasa7940170dbcd1de0@mail.gmail.com>
References: <d3561eb00604071245g52782ecasa7940170dbcd1de0@mail.gmail.com>
Microsoft has a KB article here -
http://support.microsoft.com/kb/q128809/ - you may want to look at. I
found the best way to avoid this was to use pass-through queries.
J Herbers
C K wrote:
> 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
>
> ---------------------------(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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: james@herbers.ca, shreeseva.it@gmail.com
Subject: Re: MS Access and PostgreSQL
In-Reply-To: <4436C4E0.9010205@herbers.ca>
References: <d3561eb00604071245g52782ecasa7940170dbcd1de0@mail.gmail.com> <4436C4E0.9010205@herbers.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox