Can't Save Changes to a Table (Access 2000)

[marcellus.lim]

Hey,
I have this problem with my Access 2000 database: when I try to save
changes to a table's field size it returns a message, that too many
fields were changed and it can't save it? Is there anything that can be
done? Does it have anything to do with the size of the database or
quantity of records in it? Thanx a lot!

 

[Guest]

Access has a limit of 255 fields per table. However if you delete a field,
you don't get that one back. Also certain changes can "burn up" a field.
Things to try.

1. A compact and repair just to make sure that it's not a corruption issue.

2. Create a make table query from your existing table and create a new
table. Delete the original table then rename the new table as the old.
Recreate any indexes, primary and foriegn keys, and relationships. This could
be very difficult to do if you have referiential integrity enabled.

3. Create a new database file and import everything from the old into it.

What ever you try, make a safe backup of the original database first.