I have succesfully linked the following table and view
in both MS Access 97 and 2000.
create table num_tbl(pk serial,n numeric(7,2),primary key (pk));
create view num_vw1 sa select * from num_tbl;
I have had problems wiht indexes on 97 when used on fields it
couldn't have indexed.
If you post your table & view definition (as well as Access ver)
I'll see if it works for me or not.
- Stuart
> -----Original Message-----
> From: Randall Perry [mailto:rgp(at)systame(dot)com]
> Sent: 29 August 2002 18:31
> To: pgsql-general(at)postgresql(dot)org
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: [GENERAL] Access 'field too long' error
>
>
> Getting the error:
> The size of a field is too long
>
> From access when trying to link to a view. Discovered the
> problem field is
> of type numeric(7,2). But, if I try linking to the table the
> view is based
> on, I don't get the error. So, somehow this numeric field in
> a view looks
> different to Access than the same numeric field in a table.
>
> Any ideas?
>
>
> --
> Randy Perry
> sysTame
> Mac Consulting/Sales
>
> http://www.systame.com/
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>