The KSQO option and Data Type Options(Text as LongVarChar)
may help you.
> 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?
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
In response to
pgsql-odbc by date
|Next:||From: Jean-Michel POURE||Date: 2001-04-09 06:16:31|
|Subject: Re: Help : serious problems with ODBC & Postgresql 7.1
RC2 &Access 2000|
|Previous:||From: Cedar Cox||Date: 2001-04-09 00:21:04|
|Subject: Re: Access2K Form object to use passtrough queries|