If Me.txtPassword = Me.cboUser.Column(2) ThenĭoCmd.OpenForm “frmPasswordChange”,, , “ = ” & Me.cboUser MsgBox “You need to select a user!”, vbCritical Alternatively you can save the value in a global variable and close the form. This is so the cboUser control can be referenced in other parts of the application. If Reset is false, then the main menu is opened.
#Microsoft access multiple user password
If there is a match, then the Reset column in the RowSource is checked to see if the user is required to set a new password If it is, a form is opened to enter a new password.
If it doesn’t, focus is returned to the txtPassword control. The next step is to check if the password entered matches the stored password. If, not focus is returned to the cboUser combo.
#Microsoft access multiple user code
The first task the code performs is to make sure a user has been selected. This code will be entered in the AfterUpdate event of the password textbox. Now we get into the VBA that drives the security. The user will select their name from the combobox and then the password in the textbox. SELECT tblUser.UserID, & “, ” & AS Fullname, tblUser.Password, tblUser.PWReset, tblUser.AccessLevelID I suggest the name frmLogin for the form, cboUser for the combobox and txtPassword for the textbox.įor the combobox, you will set the ColumnCount to 5, the ColumnWidths to 0 1 0 0 0 and the RowSource property to the following SQL statement or create a named query: Also set the Navigation Bar and Record Selector properties to No. You will want to restrict this form by turning off the Min, Max and Close buttons. This will be an unbound form with two controls a combobox to select the user and a textbox to enter the password. Once you have the tables setup, you can create the Login form. You can also add more fields to tblUser if needed. The above is provided as a basic example. You can use whatever and how many levels you want or need depending on your application. For this example we will have four Access levels: AccessLevelID The second table is a lookup for the AccessLevelID in tblUser. The first step is to setup the tables needed to drive the security.
I’ll be using a fairly simple example for this article, but it should give you enough to expand on for more complex needs. But if you don’t need high level security, you can secure your database using VBA. If you really need strong security on a database, you are better off using a more secure back end like SQL Server. 4.First, let me state that Access is not the most secure platform. The developer provides an overview of how many of the systems work, how you can implement building blocks, and other vital information for the development of your database. The best place to get started is the Axisbase Documentation Home.
A building block is "a data subset, list, graph, window, or report." The building blocks can become incredibly complex, such is the underlying depth of Axisbase. You will use Axisbase "building blocks" to develop your database. Note: Axisbase doesn't support standard SQL, so be careful!Īxisbase isn't the most accessible database program to use. Axisbase is slightly different from the other entries in this list in that it offers an entire database solution, with a familiar front-end interface that feels similar to Filemaker, Access or Base, but can also act as a database server like MySQL. Axisbase was brought to life by a frustrated developer, angered at the expense of forcing his clientèle to pay for Microsoft Access, though development seems to have stopped in January 2011.
0 kommentar(er)
