Too Many Fields Defined?????

That's okay, I won't tell you how much of your code/hints have made me look
good. Thanks, Duff

"David W. Fenton" wrote in message
. 97.142...
"Pete D." wrote in
:

Well I ran into it when importing and making many changes to the
fields such as adding and deleting especially using old flat files
with way to many fields. In the end all I could do was to get rid
of it was recreate the table and append the records to it. It
occurs with queries, table changes.

http://support.microsoft.com/kb/198504/en-us

OK. I never would have encountered this because I wouldn't think of
defining a table with more than, say 50 fields. And I compact often
during design stages, so I'd likely not run onto it at all, even
when I had something close to 255 fields.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

alright I created a form that usind table A as a record source. when i go to
open the form i receive an error message saying that i have too many fields
defind how can i fix this


"Pete D." wrote:

It is such a good thing that you have guys like me that can really screw up
access and find those errors you experts would never find. Pete :~)

"David W. Fenton" wrote in message
. 97.142...
"Pete D." wrote in
:

http://www.databasedev.co.uk/too_man...s_defined.html

That article makes no sense at all. Changing the properties of a
field in a table does *not* increment the field counter.

And this error is most often encountered in *forms* where you've
deleted and pasted a bunch of controls, such that you quickly reach
the 700-odd limit on controls. Compacting does *not* reset the
counter for forms -- the only way to reset it is to start a new
form, or to export/import using the undocumented
Application.SaveAsText/LoadFromtext commands.

I've been programming in Access as part of my full-time job since
1996 and have not even once encountered this error, so I would think
that it indicates a design error somewhere along the line.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/