Thread: Access 2000 & Views

Access 2000 & Views

From
"Alan R. Johns"
Date:
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?

Specs:
  Redhat 7.2
  PostgreSQL 7.1.3
  PostgreSQL ODBC 7.1.0008

Thanks for any help.

-Alan


Re: Access 2000 & Views

From
Hiroshi Inoue
Date:
"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

Re: Access 2000 & Views

From
"Alan R. Johns"
Date:
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



Re: Access 2000 & Views

From
"Henshall, Stuart - WCP"
Date:
I'm succesfully linking to Postgresql views.
One thing I did have to do to make editable views was to first create the
view as a table with a primary key then create the select rule. Then I just
created the update rules and everything worked fine.
I must admit I've had more problems linking to Access 97 than to 2000 (as 97
seems to dislike postgresql indexing things it can't). Admitably I'm using
psqlodbc7.01.0006. I really must get around to updating :)
- Stuart

> -----Original Message-----
> From:    Alan R. Johns [SMTP:alan@graphicsuniversal.com]
> Sent:    Wednesday, November 07, 2001 1:34 AM
> To:    pgsql-odbc@postgresql.org
> Subject:    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
>
>