Access Table - Maximun Number of Fields?

[Zoe]

What is the maximum number of fileds allowed in an Access 2002 table? In an
Access 2007 table?

As always, any aassistance is greatly appreciated!

Thank you,
Zoe

 

[boblarson]

255 fields (which you really shouldn't come close to if you have a properly
designed and normalized relational database).

--
Bob Larson

Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

 

[Guest]

That is, 16+ text fields at 255 characters each would be too long
if you try to actually put 255 characters in each field.

But only half as many if text compression is turned off, because
'uncompressed' text fields take 2 bytes per character.

Numeric fields always use up a fixed amount of space. Memo fields
flow into other pages.

(david)

 

[Tony Toews [MVP]]

Memo fields flow into other pages.

It's my understand that memo fields are put onto their own pages. All
that is in the record is a link to the page(s) containing the memo
field taking, presumably, 4 bytes.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Guest]

Could be, I thought that in Jet 4, like in SQL Server, short
memo fields could be contained in the base page.

(david)