MS Access-User Can Replace My AutoExec Macro

Question

I cannot figure out how to prevent someone with the password to my Access database from importing their own AutoExec macro and replacing the one I have already included.  Is there a way to stop this? (I am using Access 2016)

Answer 1

I would suggest you drop the AutoExec, and make a “simple” tiny form that has no controls etc. and specify that form as start-up. That form can then run the same macro code, or some VBA code, and then when done can launch the start-up form.

So you don’t necessary require an AutoExec macro, and you can/could use a “dummy” form for this purpose.

Regards,

Albert D. Kallal (Access MVP, 2003-2017)

Edmonton, Alberta Canada

Answer 2

Hmm, Who are your users? If these are corporate users on a LAN then monkeying with a corporate app is a serious offense.

What does your Autoexec macro do? Why is someone trying to bypass it?

Answer 3

Review http://www.devhut.net/2016/09/01/securing-your-ms-access-database-front-end/

If you use your own custom ribbon, hide the nav pane, disable the shift bypass,... And distribute it as a compiled accde, you should have any real issues.

Answer 4

I did make an accde copy, but found that macros can still be imported in and override any pre-existing AutoExec.

Answer 5

Why not distribute it as a accde, then they can't make design changes.