Creating Logon in MS Access

Hi All,

can you help me how to create my ms access when first time open always ask " logon "

as below picture :

I mean can we create this using macro.When someone try logon wrong can't get in.

Thank for advise ...



Answer this question

Creating Logon in MS Access

  • John Padilla

    Hi Bro..

    can you give more detail ...thanks


  • AlexBB

    Hi,

    Access has this sort of feature built in. Its called Workgroups. If you look in the toolbar under Tools->Security->Workgroup Administrator... this will let you create users and groups for accessing the database in a similar way to creating users and groups for Windows. When a user opens the database they are prompted for a password.



  • Deunan

    Im not sure if you want to use VBA !

    You can create a Form in MS Access and use it as a default.

    Regards

    Shasur



  • Creating Logon in MS Access