VJD
Nov 26 2003, 02:24 PM
How many fields can you have in a table? I've got 191 and it won't let me save it. Does anyone know?
khaos
Nov 26 2003, 02:29 PM
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
VJD
Nov 26 2003, 02:40 PM
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?
cdbackslash
Nov 26 2003, 02:47 PM
khaos already answered...it's 255. Look in the help for: Access specifications
I second the motion about table normalization.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please
click here.