Too many fields

[bpz]

I am receiving the error message "Too Many Fields Defined" when trying to add
a column. I have seen previous posts about Compact and Repair, but I am not
understanding where to find this on Access 2007. Is there a particular view I
should be in? I know I need to restructure the database, but do not have time
right now.

 

[Jeff Boyce]

NOTE!! backup your file before running C & R.


In A'07, click the 'belt buckle' in the upper left corner, find & click
"Manage", then "Compact & Repair".

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[bpz]

Thanks Jeff! Amazing how easy things are once you know where to find them.
Worked like I needed it to.

 

[Jeff Boyce]

Just a side note, in case you hadn't run across this before ...

It is ... unusual ... to have a well-normalized relational table with more
than 30 fields.

If your table has more, consider posting a description of what you're
storing in that table to the tablesdbdesign newsgroup for alternate
approaches...

Regards

Jeff Boyce
Microsoft Office/Access MVP