MS Access 2007 autoexec macro alernatives?

I'm having an issue with program distributed via Microsoft Access runtime. It runs an aut开发者_如何学编程oexec macro at the beginning to run a piece of code. I've done all the security setting and trusted zone settings, but the error seems to crop up on Windows 7 installations.

Ideally, I'd just like to have the code run automatically without the autoexec macro. Is there any way to do this?

I just read that you could set the starting form with Access options. Then I could run the code from the "OnLoad" event. That might work...