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?