access unresponsive

[joanne21]

Has anyone written code behind command buttons which suddenly stops working. A command button running a simple if statement has stopped responding. Now, none of the buttons work.

[JoeM]

Sounds like your VBA & Macros may have been disabled (a security setting).
If that is the case, you will either need to enable the VBA/Macros when you open the datasbase, or add a Trusted Location in your Trust Center settings.

[ieuan]

Worse, your access file is corrupted.

[JoeM]

Worse, your access file is corrupted.

It may be, but I wouldn't jump to that conclusion until you rule the other things out. In my experience, the Macro/VBA Security Settings is quite often the culprit.

If it is indeed corrupted. Try creating a new Access database, and then import all your objects from the old one to the new one, and see if it works then.