From: Tim Bosinius <tim@bosinius.de>
To: 'David Hartwig' <daveh@insightdist.com>
Cc: 'pgsql-interfaces@postgreSQL.org' <pgsql-interfaces@postgreSQL.org>
Subject: RE: requested Logfile - Access97
Date: Wed, 3 Jun 1998 22:29:16 +0200
Message-ID: <01BD8F3F.0DCE7DF0.tim@bosinius.de> (raw)
>You must have specified a multi-part key. If you cut this query out and run
>it in the psql monitor you will see that it is a problem in the backend
>server. We are currenly discussing how to resolve the problem. Hopefully it
>will be resolved in the next release.
I followed the issue on the mailing list. I believe that the backend should handle it.
So - Method 3 in your mail to Hannu Krosing ;)
> In the mean time. There is something
>you can do for queries. Turn off "Recognize Unique Indexes", and relink the
>tables in Access. When you relink do NOT select a primary key. This will
>greatly speed your queries, but the table will be read only.
Ok - this works pretty good. I created two ODBC entries for the same database/table
one for my VB program the other for Access97(I need this for Winword documents)
Byron said that version 244 will fix the MS Query problem. which is even better
than using Access.
(Maybe that also helps Jose' Soares Da Silva problem?! - see mailinglist)
Regards,
Tim Bosinius
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tim@bosinius.de, daveh@insightdist.com
Subject: RE: requested Logfile - Access97
In-Reply-To: <01BD8F3F.0DCE7DF0.tim@bosinius.de>
* 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