Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Hi Tasmin,
The KSQO option and Data Type Options(Text as LongVarChar)
may help you.

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?

In response to

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group