If like me you are used to developing many applications in Access and have been used to ticking a box on the startup options in Access 2003, you've probably been pulling your hair out trying to do this simple task in Access 2010.
Firstly I must point out this is not a solution per sae, it is a work round in a specific environment.
MS seem to have made a step backwards with regard to application development in Access 2010 and removed this simple start up option tick box!
So ensure you understand this statement before trying to implement this 'fudge'.
Every form in your application MUST be set to 'pop-up' and 'modal' (with the exception of sub-forms)
So if your application requires non-modal forms, you CANNOT hide the Access application DB shell!
OK, so with that in mind, and ensuring ALL your forms are 'modal' simply add the following to the main module (Global Code)
Declare Function apiShowWindow Lib "user32" Alias "ShowWindow" (ByVal hWnd As Long, ByVal nCmdShow As Long) As Long
This declares a function for use from the windows API "user32" library.
Then in your main form of the application add the following to the 'form_open' form event handler procedure
Dim lWin As Long lWin = apiShowWindow(Application.hWndAccessApp, 0)
It's worth noting you can unhide the DB window with