Message-ID: <01BD8F3F.0DCE7DF0.tim@bosinius.de>
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
Encoding: 22 TEXT

>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