MS Access 2002

  Slack Alice 16:20 01 Aug 2007

Hi all,

I am using MS Access 2002 and the database I have has 21 columns in and I need to add an additional 2. When I try and insert a column I receive the error message ‘Too many fields defined’. I have tried getting around this by deleting a surplus column and then trying to add a column, but still have the same error message comes up.

The on-line help seems useless… any ideas what I can do?

Best regards,


  Woolwell 17:34 01 Aug 2007

Access 2002 will allow you to define 255 fields in a table so your error messgae is rather typically misleading.

This may help click here;en-us;Q128221

  Woolwell 17:45 01 Aug 2007

Try this
click here

  Woolwell 17:48 01 Aug 2007

The advice is for older versions of Access. When deleting fields and adding them I only normally do this in design view.

  Slack Alice 16:08 02 Aug 2007

I have now managed to add columns!


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

Halloween Photoshop & Illustrator tutorials: 20 step-by-step guides to creating spook-tacular…

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?