Assuming that you are talking about a table and not a query:
1. Compact and repair the database.
2. Use a make-table query to create a new table out of the old one. Then
rename the old table to something different and the new table as the same
name as the original. This may not work if you have relationships set up.
3. How many fields are we talking about? If you have over 50 fields in one
table, it's very likely that your data is not properly normalized. If the
word "normalized" doesn't ring a bell, I highly recommend getting some
relational database training or reading "Database Design for Mere Mortals" by
Hernandez before proceeding any further on this database.
