Login screen

[eforce]

I've created a program in Access in which the user is confronted with a Switchboard form with 6 buttons which access seperate accounts. I am currently using the security wizard to inhibit users from getting access to others sections but I now want to create a stand-alone version (user doesn't need MS Access) with MS Office XP Developer.

My problem is that if I include my system.mdw in the setup package then everytime they open MS Access it's going to ask them for the login and password rather than simply asking for this info to work in my program. It's like my system.mdw file is replacing their system.mdw file and I don't want that.

Does anyone having any example forms I can use that will ask a user for their login and password and then restrict their access based on their input.

Thanks,

Danny

 

[wh00t]

change or re-do the mdw file naming it something else, and point to this file on the short cut

 

[eforce]

What shortcut?

Thanks for responding. You say have it point to a shortcut. What shortcut is that?


Thanks
Eforce

 

[wh00t]

create a shortcut to the db that looks at the correct security file

C:\PROGRAM\Microsoft Office\MSACCESS.EXE "C:\whatever\whatever.mdb" /wrkgrp "C:\wherever\whatever.mdw"