MsgBox 'You do not have access to this database. 'If User Enters incorrect password 3 times database will shutdown Please Try Again', vbOKOnly, 'Invalid Entry!' 'Close logon form and open splash screen (could be Switchboard or another form instead)ĭoCmd.Close acForm, 'frmLogon', acSaveNo 'substitute correct name if using 'form other than frmLogon in the example.ĭoCmd.OpenForm 'frmSplash_Screen' 'substitute correct name if using switch 'board or other form. If Me.txtPassword.Value = DLookup('strEmpPassword', 'tblEmployees', '=' & Me.cboEmployee.Value) Then 'Check value of password in tblEmployees to see if this matches value chosen in combo box MsgBox 'Password is a required field.', vbOKOnly, 'Required Data' If IsNull(Me.txtPassword) Or Me.txtPassword = '' Then 'Check to see if data is entered into the password box MsgBox 'User Name is a required field.', vbOKOnly, 'Required Data' If IsNull(Me.cboEmployee) Or Me.cboEmployee = '' Then 'Check to see if data is entered into the UserName combo box 'After selecting user name set focus to password field Changing the code to reflect the appropriate form name is required for this. This splash screen may be replaced with a switchboard form or another form of the designer's choice. A userform/splash screen displays when a log in is successful. All passwords in the example file are: password. Three unsuccessful tries at the password result in the application shutting down. Additional coding could be implemented to disallow certain elements of the database to different levels of users. Nothing in this example is done with the access levels. This data table would ordinarily reside on the server. The data table consists of the username, the associated password, and the associated level of access. In this example, the data table is contained in an Access database as a remote connection is problematic. The process of creating forms, reports, data access pages, macros, and modules is virtually the same as that used to create an Access database.

Working with an Access project (.adp file) is very similar to working with an Access database (.mdb file). In the case of an Access project (for example, an Access front end to a SQL Server database) this will be of more use than in the case of an Access database. This SHOULD NOT be mistaken for a security measure as it is easily bypassed by holding the shift key down or switching to design mode.

This log in example illustrates the steps to require users of an Access database file to login. After 3 unsuccessful attempts, the application shuts down. This example begins with a log in form consisting of a combobox, a text box and a command button.

Ms access password field