My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 how any fields can a table hold ?
|
|
 Sep 5 2008, 08:08 AM
Post
#1
|
|
|
UtterAccess Addict Posts: 239  |
how any fields can a table hold in access?
how about in sql server |
 |
 
|
|
Sep 5 2008, 08:16 AM
Post
#2
|
|
|
UtterAccess Veteran Posts: 304 From: Baltimore, MD |
255. Here's more:
http://blogs.msdn.com/access/archive/2006/...007-limits.aspx |
|
|
|
|
Sep 5 2008, 10:49 AM
Post
#3
|
|
|
UtterAccess Guru Posts: 578 From: Florida, USA |
In Access Help, just type in the keyword "Specifications" and you can find the specification limits for tables , forms, etc.
|
|
|
|
|
Sep 5 2008, 12:31 PM
Post
#4
|
|
|
Retired Moderator Posts: 13,544 From: Texas (Is there anywhere else?) |
255, but there are only very few valid reasons to have that many fields in a normalized relational database. What is driving the need for that many fields?
|
|
|
|
|
Sep 5 2008, 01:16 PM
Post
#5
|
|
|
UtterAccess Editor Posts: 15,974 From: Northern Virginia, USA |
It may be more important to inform you of the row size limit of 4096 bytes, so ... you could have 16 fields of datatype text with a field size of 255 in a table, and if your users don't get too overzealous, you'll be good to go! ... but if a user consumes all 255 characters of each text field, Access will tell you that you have done something wrong!! ...
But do take note the Memo fields (which are only limited by the size of the database) only take up 8 (I think) bytes in a row because what is stored in the table is a MEMORY LOCATION that points to the block of text input in that memo field. ... SQL Server (I *think*) has a 1024 column quantity limit with a row size limit of 8060. |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 22nd May 2013 - 05:34 PM |