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

__________________________________

 

[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)