I figured out exactly how i am going to make my database work the way i want and i went to add one more field to a table (that holds 12 fields) and when i go to save it it says (too many defined fields, must delete some). well i deleted some and it still gives me the same error. Help anyone?

See this answer that I JUST posted.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=59038

this didn't solve the problem

what i ended up doing is copying the data into a new table and then deleting the old table, then renaming the new table to the same name as the old table. this works now.

something must have been screwy with the old table.