Re: Access 2000 & Views

Sorry... I thought maybe this was a common error.

I don't know how to provide a simple example other than to ask this
question:

Using Access 2000 and the PostgreSQL ODBC driver (v7.1.0008), has anyone
successfully linked to a view in a PostgreSQL database (just like you would
link to a table)?

If the answer is yes, then I need to look in another direction for the
answer to my problem.

Thanks for the help.

-Alan

-----Original Message-----
From: pgsql-odbc-owner@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org]On Behalf Of Hiroshi Inoue
Sent: Tuesday, November 06, 2001 7:56 PM
To: Alan R. Johns
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Access 2000 & Views


"Alan R. Johns" wrote:
>
> I'm having a problem when trying to link to a PostgreSQL view from Access
> 2000. I get the following error: "The size of a field is too long.". There
> is nothing "long" about any of my fields and I've tried to link to even
the
> simplest of views receiving the same error. Regular tables link with no
> problems.
>
> With Access 97, the exact same view(s) will link just fine and are fully
> accessible. Am I missing something?

Could you give us a simple example ?

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org