Re: access #s_c_h#

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Tamsin <tg_mail(at)bryncadfan(dot)co(dot)uk>
Cc: postgres odbc <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: access #s_c_h#
Date: 2001-04-09 01:16:27
Message-ID: 3AD10D6B.261FEFA8@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi Tasmin,
See ftp://ftp.postgresql.org/pub/odbc/configuration.html.
The KSQO option and Data Type Options(Text as LongVarChar)
may help you.

regards,
Hiroshi Inoue

Tamsin wrote:
>
> Hi,
> using access as a frontend to postgres, mainly using linked tables, and i'm
> trying to optimise the perfomance. Just wondered if anyone had any
> experience with the following:
>
> ksqo - i know access uses keyset queries, so the key set query optimiser
> needs to be on, but access sets this everytime it accesses the database -
> can I set this in the postgres configuration so that access doesn't have to
> set it each time? (it does the same thing for datestyle too) is it worth
> worrying about this at all?
>
> memo fields - I have some text fields in postgres, which access treats as
> memo fields, so when it runs query, it replaces the memo field with #S_C_H#,
> and then does a separate query to get the value of the field. however, in
> my access form I have a datasheet with memo fields in it, so access ends up
> running an extra query for the memo field in each row, which is really slow.
> Is there any way to stop access from doing this so it just retrieves the
> text fields with the rest of the data?
>
> thanks,
> Tamsin
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Jean-Michel POURE 2001-04-09 06:16:31 Re: Help : serious problems with ODBC & Postgresql 7.1 RC2 &Access 2000
Previous Message Cedar Cox 2001-04-09 00:21:04 Re: Access2K Form object to use passtrough queries