RE: requested Logfile - Access97 - Mailing list pgsql-interfaces

From Tim Bosinius
Subject RE: requested Logfile - Access97
Date
Msg-id 01BD8F3F.0DCE7DF0.tim@bosinius.de
Whole thread Raw
List pgsql-interfaces
>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


pgsql-interfaces by date:

Previous
From: "Jose' Soares Da Silva"
Date:
Subject: Re: [INTERFACES] pgaccess 0.86
Next
From: "Jose' Soares Da Silva"
Date:
Subject: PgAccess running on Win95 ?