This is probably going to sound stupid, but Access no longer asks me if I want to save when I close a form , query or table when I've been editing it. This only seems to be happening in one particular mdb file. Anyone have any idea on how to fix this?
Have you turned warnings off in any of your code? If you have SetWarnings = False, then the save windows won't come up anymore. Look for any code where this may exist and make sure that at the end of the code you turn the code back on.
You can check to see if this is the problem by closing your database, then see if the save prompt is back.