Upsizing and Limit of number of fields

C

Cheri

Hi,
Does anyone know if you upsize your Acess 2002 db does the limitation of 255
fields per table go away (the new limit would be that of SQL- 8000chars)? I
know...I shouldn't have a table with 255 fields, but let's assume I do.
thanks,
 
R

Rick Brandt

Cheri said:
Hi,
Does anyone know if you upsize your Acess 2002 db does the limitation
of 255 fields per table go away (the new limit would be that of SQL-
8000chars)? I know...I shouldn't have a table with 255 fields, but
let's assume I do. thanks,
Click to expand...

It goes away as far as building the table on SQL Server is concerned (its limit
is much higher), but you would not be able to link to that table from Access as
it would still protest about the number of fields in the link.

(I'd fix that table)
 
Top