Re: [GENERAL] Access 'field too long' error

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@systame.com]
> Sent: 29 August 2002 18:31
> To: pgsql-general@postgresql.org
> Cc: pgsql-admin@postgresql.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
>