Skip site navigation (1) Skip section navigation (2)

Re: Access 2000 & Views

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: "'Alan R(dot) Johns'" <alan(at)graphicsuniversal(dot)com>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Access 2000 & Views
Date: 2001-11-08 20:12:37
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F74717@MAIL_EXCHANGE (view raw or flat)
Thread:
Lists: pgsql-odbc
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
> 
> 

pgsql-odbc by date

Next:From: Mike MillerDate: 2001-11-08 21:37:22
Subject: Re: ODBC & Transactions?
Previous:From: Bruce MomjianDate: 2001-11-08 20:05:54
Subject: [PATCHES] MD5 support for ODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group