I have to begin by giving JeremyNYC a big Thanks for helping me figure this one out.....Without his help, I may never have reached the final product!
One of the most annoying things I found about using a secured database, is the fact that you cannot change the little form that prompts for user name a password. You spend all the time developing this great application/database, and you are left with this ugly little form. Well, Although I haven't found a way to modify it, I have found a way around it...
The below instructions walk you through setting up an intermediary database...with a nice login form as you want it. The users will enter their username and password here, which will be passed as parameters to a shell command to open the normal database, bypassing the little login screen normally associated with secured databases.
First, develop your database as you want it. Get it all set up with your security and everything.
Next, create a separate database. Place one form in it, and set this form to be started automatically. On the form, put two text boxes and two commmand buttons. One of the command buttons is for Cancel and only has: DoCmd.Quit for its OnClick event procedure.
Name the text boxes User and Pass. Set the InputMask propterty of the Pass box to Password
The final command button is Login and gets the following code in its OnClick event:
'******** Start Code *********** Dim strPath As String