Access Runtime does not execute VBA code

Question

favorite

I have been developing an Access database with VBA code for a few months and it has been working fine, until last week. The last night it worked, I added some code I found online to "bypass the bypass" (#3 at<br>http://www.techrepublic.com/blog/10-things/10-tips-for-securing-a-microsoft-access-database/). I went into and out of my database a few times, no problem.<br><br><br><br>   I shut down the laptop, but the next morning, when I pressed any of the command buttons, none of the VBA code would execute. I tried multiple previously saved copies of the database, none of the buttons work. I even tried a couple of different databases,<br> no buttons work. But when my coworker tried my original database, it works fine.<br><br><br><br>   I have recompiled, compact and repair the database and my IT department has uninstalled and reinstalled MS-Access, but no change in symptoms. I am stumped. I am running Access 2010 (32 bit) and Windows 7 Professional.<br><br><br><br>   So, I commented out the "bypass the bypass" code I copied from the link above (the last code added before this issue showed up), then created a brand new database, imported all of the tables, data, queries, forms and modules. The VBA code worked. I pressed<br> the buttons and they worked as expected. The code needed to be compiled, and it still worked after compiling. But once I performed a compact/repair, and the database closed, when I reopened it, the buttons did not work.<br><br><br>   Any help would be appreciated. Thanks.

Answer 1

Sounds like your database is longer in a Trusted Location.  I would check that and see if that resolves your problem.

Answer 2

Glad that worked!

Did you change it's location?  Other than that the only thing that comes to mind is something you *tried* the night before rest something and set you back to default which removed your set Trusted Locations.

Answer 3

Thank you for the suggestion. I read Gina Whipp's suggestion first and tried it and it worked. But I did Google "decompile" and bookmarked the web page that described it. I had never even heard of a decompile, so your suggestion did teach me something and I can use all the tools I can learn.

Answer 4

Thank you very much. I followed your suggestion and it did fix my problem. My VBA code works again. I don't know what I did or if I caused this. How does my database lose its trusted location? I know I didn't change this.

Answer 5

That, or perhaps a Decompile.