Thanks David. I did get more fields added but the article helps me to
understand how to fix this problem should it arrive in the future.
Hopefully I'll never want that many fields again.
Don............
"David Lloyd" <David@NoSpamPlease.com> wrote in message
news:h1d1f.3293$X8.785@bignews5.bellsouth.net...[color=blue]
> Don:
>
> The following KB article deals with the issue Randy mentioned.
>
>
http://support.microsoft.com/default...b;en-us;291556
>
> --
> David Lloyd
> MCSD .NET
>
http://LemingtonConsulting.com
>
> This response is supplied "as is" without any representations or[/color]
warranties.[color=blue]
>
>
> "Don Sealer" <vze2t273@verizon.net> wrote in message
> news:Hw%0f.2437$7P5.2206@trndny07...
> Thanks David that's really handy.
> I see where in Access 2000 (which I'm using) it says I can have 255 fields
> in a table. However I have, as near as I can count 126 fields in one of[/color]
my[color=blue]
> tables. When I try to add another I get a message "too many fields
> defined". I thought this meant I had too many. Now I'm not sure what it
> means, do you have any idea?
> Thanks for the tip,
> Don............
> "David Lloyd" <David@NoSpamPlease.com> wrote in message
> news:qf%0f.1165$49.874@bignews7.bellsouth.net...[color=green]
> > Don:
> >
> > For Access 2003, the maximum number of fields is 255. If you go to[/color][/color]
Access[color=blue][color=green]
> > help and search "Access Specifications" you will find a help topic[/color]
> detailing[color=green]
> > the various limits in Access.
> >
> > --
> > David Lloyd
> > MCSD .NET
> >
http://LemingtonConsulting.com
> >
> > This response is supplied "as is" without any representations or[/color]
> warranties.[color=green]
> >
> >
> > "Don Sealer" <vze2t273@verizon.net> wrote in message
> > news:HqZ0f.2599$ar6.284@trndny01...
> > Can you tell me how many fields Access will allow in a table. As I[/color][/color]
stated[color=blue][color=green]
> > in a previous post, I need to track multiple measurements from machines[/color][/color]
10[color=blue][color=green]
> > per day. In some cases this will give me 120 measurements or more. I[/color]
> could[color=green]
> > put one check on one record but I was hoping to find a way to put all 10
> > checks (120 measurements) into one record. So far I really haven't[/color][/color]
gotten[color=blue]
> a[color=green]
> > reply I understand other than do one record per check.
> > I've been trying to do:
> > Check#1 measurement, measurement, measurement, etc
> > Check#2 measurement, measurement, measurement, etc
> > all the way to
> > Check#10 measurement, measurement, measurement, etc.
> > Now this method will work but I have to create 120 fields to do it.[/color][/color]
When[color=blue][color=green]
> > I've tried Access tells me it's too many fields.
> > I was wondering how many fields you can actually have?
> > Don.............
> >
> >
> >[/color]
>
>
>[/color]
