UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> # of fields in a table    
 
   
VJD
post Nov 26 2003, 02:24 PM
Post #1

UtterAccess Member
Posts: 43
How many fields can you have in a table? I've got 191 and it won't let me save it. Does anyone know?
Go to the top of the page
 
+
khaos
post Nov 26 2003, 02:29 PM
Post #2

Retired Moderator
Posts: 8,589
From: Lansing, MI
You can have 255 fields, but anywhere near this many probably means your table is not normalized and you may want to look into this before continuing your project. Check the faq forum here at UtterAccess for some great tips on this and other subjects.

HTH
Ken
Go to the top of the page
 
+
VJD
post Nov 26 2003, 02:40 PM
Post #3

UtterAccess Member
Posts: 43
You can have 255 characters in a text field........I need to know how many fields you can define in a table. Is that 255 also?
Go to the top of the page
 
+
cdbackslash
post Nov 26 2003, 02:47 PM
Post #4

UtterAccess Veteran
Posts: 388
From: Missouri, USA
khaos already answered...it's 255. Look in the help for: Access specifications

I second the motion about table normalization.
Go to the top of the page
 
+
« Next Oldest · Access Tables + Relationships · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 07:15 PM