Thread: Access 2000 & Views
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
"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
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
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 > >