Re: Problems with ODBC and Access

From: Eric E <whalesuit(at)bonbon(dot)net>
To: Michelle Murrain <tech(at)murrain(dot)net>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Problems with ODBC and Access
Date: 2005-02-15 19:42:38
Message-ID: 421250AE.6000702@bonbon.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi Michelle,
Sorry to hear about your woes with Postgres and Access. I am
currently using Access 2K3 (previously Access 2K) with PG 7.4. It
sounds like you've covered these bases, but let's just run down the
checklist:
1) Fields have primary keys, and your linking process in Access is
recognizing those PKs.
2) In your ODBC DSN Row Versioning is checked (page 2 of Datasource
options)
3) The connecting user has permission to select, update, etc.
relevant sequences?
4) All clients are using Access 2K? I had a problem that took me a
while to diagnose - Access 2K3 will not properly handle memo fields if
the table links were made with Access 2000 - perhaps your problem could
be related?
5) If you turn on query logging, either on the client side or server
side or both, the SQL preparation and execution statements are being
properly formed?

Hope some of that helps.

Cheers,

Eric

Michelle Murrain wrote:

> Hi All,
>
> We have a MS Access 2000 database connecting to psgl 7.4.5 database
> over the Internet using ODBC 7.03.02.00 drivers. The connection works
> sometimes and then fails sporadically and unpredictably. When it
> fails, it could be just opening a table or it could be in a bound
> form. When it fails, we sometimes get an ODBC connection error.
> Sometimes, the table opens up with each cell filled with #delete#. I'm
> looking for some general troubleshooting guidelines.
>
> What makes this frustrating is that we have other experience using
> essentially the same techniques that have much greater stability. We
> are reasonably proficient with both pg and Access in general, and have
> naive to moderate experience, but until now good luck with the odbc
> drivers.
>
> I could say more about what we have checked or have suspected.
> Bandwidth? Table relations? Presence of text/memo fields? nature of ID
> fields? For initial post, I think I will just see what pops up. Very
> frustrating.
>
> Thanks for any tips, experience, suggestions.
>
> Michelle
>
> Michelle Murrain
> mmurrain at dbdes.com
> 617-248-0007
> 952-674-7253 fax
> Page: pageme(at)murrain(dot)net
> AIM:pearlbear0 ICQ:129250575
> Yahoo:michelle_murrain MSN:michelle(at)murrain(dot)net
> Jabber: pearlbear(at)transactim(dot)net
>
> In separateness lies the world's great misery; in compassion lies the
> world's true strength. -- Buddha
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Eric E 2005-02-15 21:48:39 Re: Problems with ODBC and Access
Previous Message Steve News 2005-02-15 19:22:35 Re: Problems with ODBC and Access