Maximum size for Record?

[cariengon]

Is there a maximum allowed size for a record? And if there is, what is that size?

I have a large table that if the user was to attempt enter data into every field, it returns the "record too large" error when you get to the last 10 fields of the record - and won't allow any data entry into more fields...

I can work around it, but this information would be helpful when desinging future databases...

Thanks,
Carie

 

[PHV]

In ac2003: 4000 characters (except memo and OLE fields) with unicode compression.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886