Access 2K Error: too many fields defined.

[Guest]

I have an Access 2K user that gets the following error
message when he tries to add fields to a table:

Error: too many fields defined.

Any ideas? Is there a limit on how many fields that can
be defined?

Thanks.

 

[Douglas J. Steele]

255 fields, which should be at least 200-225 fields more than you'll ever
need, assuming the database is properly normalized.

However, you can get that error message if you're adding and deleting fields
and haven't compacted the database.

 

[tina]

open Access, open Help, type Specifications in the Answer
Wizard tab, and you'll find the field limit for a table -
as well as everything else about Access specifications.
hth

 

[Douglas J. Steele]

How many fields have you added? There's a limit of 255.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

I have the same problem. But neither compacting nor the help function

work. I tried detect and repair as well. Any other suggestions?