I'm using Access 2007. The file is in Access 2003 format.
When I try to make changes to a particular form, if I close without saving, it prompts me to save as usual. But the form won't close. When I close and opt to not save, changes aren't saved.
It doesn't matter if I do this at work or at home. Either way I know for a fact no one else is using the MDB, simply because I don't get an error saying so, and I'm doing this late enough I know everyone else is gone. And of course on my home PC, I'm the only one using it!
If I manually save and then close, I'm still prompted to save the form, and the same thing happens:
1) Form won't close
2) When I close, I'm prompted to save
3) When saving, the form won't close
4) The only way to close is to NOT save the changes
There are quite literally NO errors at all. I've done quite a bit of googling in the past 2 hours and only found this one bit that may help:
"There's a max of 7xx (seven hundred something) controls you can add, and removing a control doesn't decrease the talley." I'm guessing this form may be at it's supposed design limit or something. It has been through EXTENSIVE design and re-design. I suppose I should also mention that this form is very complex. But it works fine. All references are found, etc. Just won't save any more changes. Seems like a re-design is due...
I've had this happen before, but I can't remember how I did it. I think it was the result of random tinkering.
In the meantime I'm gonna tinker, and hope I don't mess anything up worse. (Usually I don't, I'll just spin my wheels and burn out, or get lucky.)
PS. Thanks for all the help in the past. My database has helped with work load a TON, and it's all thanks to the help I got here.