simply adding a field

[Woodworker]

Total newcomer on forum, and minimally experienced with Access. We are a very small company and have a very simple, single table customer tracking db. Nobody here has used it in years. I'm rejuvenating it for sales lead management, and I've added a new field to the table. No big deal.

It's running on our network server, and nobody is aware of any admin ever being set up. I expect wide open editing ability.

But when I add that new field into Forms they won't "Save and close". It just won't close at all with the changes. But the new field remains in the "Tables" and in the extended version under "Queries".

Might security settings be keeping me out? Can I simply clear them out somehow?

Thank you for any and all assistance.

[orange]

You added 1 field to a table. What is the record source of the Form? Is that new field in the record source?
Can you post a dumbed down version of your database (remove personal/confidential info)?

[Woodworker]

I've deleted most of the content in a copy of the DB, still can't add to this reply as an attachment. I think it's still too big at 7,040KB (looks like 500 is max). How else to "post" it?

As far as I can tell in our DB, the forms, query and table all tie to the same records source... there's only the one table, and that is what is referred to as the "record source", correct?

tnx

[orange]

You should run Compact and Repair to remove any "bloat" in the database.
Also, to make the file even smaller for posting ===> Zip it, and attach the .zip file

[Woodworker]

DB file is still 2400KB in zipped form.... max of 500 leaves me with error msg that can't attach it.

BTW - the new field does show up in the "add existing fields" list when I'm in layout view. And I can drag it into the Form... but then I try "save and close" and absolutely nothing happens. If I use the simple "save", then exit the application and re-enter, the field is not in the form. I can re-open, put the field back in the Form thru layout, and work with the form using it and new data entries are saved in the table properly. But when I close the DB it asks me if I want to save, I say yes, and again nothing happens. I can't close out until I answer "no" to saving. Then upon re-opening, the data for the new field is in the table, but the forms don't show it.

This problem seems so..... silly. But I sure can't figure what's locking me out of changing the Forms.

[orange]

Strange for sure??????