How to Add New User in Log-in form and connect to Access in VB.Net?

[hyperion0]

So, I created a program in VB.Net with Windows Form and I want the user to be able to create a new user, limited to 5 user accounts only. I also want to know if it's possible to change password and delete user accounts.

Can I make it so that each User has their own MS Access database? For example, User 1 can only access Database1 but not Database2. And User 2 can only access Database2 but not Database1.

Here is the log-in form that I created that can only have one user account:

Public Class Form3
    Private Sub Register_Click(sender As Object, e As EventArgs) Handles Register.Click
        Try
            My.Settings.Name = NameTxt.Text
            My.Settings.Username = Username.Text
            My.Settings.Password = Password.Text
            My.Settings.Avatar = OpenFileDialog1.FileName
            My.Settings.status = True
            My.Settings.Save()
            MsgBox("Your account was successfully created.", MsgBoxStyle.Information)
        Catch ex As Exception
            MsgBox("Account failed to register.", MsgBoxStyle.Critical)
        End Try
    End Sub

    Private Sub LinkLabel1_LinkClicked(sender As Object, e As LinkLabelLinkClickedEventArgs) Handles LinkLabel1.LinkClicked
        Try
            OpenFileDialog1.Title = "Add Picture"
            OpenFileDialog1.FileName = ".png"
            OpenFileDialog1.Filter = "All Files|*.*"
            OpenFileDialog1.ShowDialog()
            PictureBox1.Image = System.Drawing.Image.FromFile(OpenFileDialog1.FileName)
        Catch ex As Exception
            'Do nothing'
        End Try
    End Sub
End Class

Is it possible to do that using only Settings of the project? Or do I really need to use MySQL (as I've seen from youtube tutorials)? I am only a beginner with little knowledge about programming, so please bear with me if my questions seem silly.

[rproffitt]

The answer to most if not all the questions is yes. I wish folk would number their questions and always end a question with a question mark so everyone can find the question and answer them by the numbers.

But I'm going to stop here and note that if the user can create the logins then there seems to be no reason to have any user security since this person created all 5 accounts. It's one really odd design and even odder to limit it to five. Hardcoding that limit may be adding complexity where leaving it to nearly unlimited might be better. That is, you do the usual please enter you account name then password and check if they are a current user and if so connect to their database.

And yes, SQL would be a great step up in learning the better methods and can push the security back into the database since leaving it in your app means the database is usually insecure.

As to being new, that wears off in time. Mostly by continuing classes and tutorials.