[Access 2007] VBA Security Issue with accde?

[RobDog888]

I have an Access 2007 accdb database and upon opening of the db a form shows via startup form. In this form is some VBA ADO code to authenticate the windows logged in user as well as setting up the visible controls associated with the login and some other "stuff".

Problem is that the db fails to run some VBA code when converted into an accde file. I'm thinking its Sandbox preventing some of the code from running but then why does the db run fine when an accdb?

Any thoughts?

[Siddharth Rout]

Is the ACCDE file in a trusted location? Also Check that you have no issues with your VBA references. If you have any issues with the VBA references, you will not get a prompt like in Access 03. The simply won't run...

An alternative could be this....

Start from a new DB and then slowly import the objects back about 10 at a time, compile it, make it an .ACCDE, check it and continue on. Don't import everything together else it might fail again.

Edit
Also check this thread. See if it helps...

[RobDog888]

Yes the netowrk location was added to teh trusted locations in the db. No prob with refs since the accdb runs fine from the same location.
Still have the original accdb so I can keep trying new accde's. I'll take a look at the link now.