Re: Access 2000 & Views

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(at)graphicsuniversal(dot)com]
> Sent: Wednesday, November 07, 2001 1:34 AM
> To: pgsql-odbc(at)postgresql(dot)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(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org]On Behalf Of Hiroshi Inoue
> Sent: Tuesday, November 06, 2001 7:56 PM
> To: Alan R. Johns
> Cc: pgsql-odbc(at)postgresql(dot)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
>
>