okay, so i am designing a login system which is connected to a preset database i made in ms access. here's the code that i have written:

Code:
Private Sub cmd_ok_Click()
    
    'Declare variables
    Dim db As DAO.Database
    '= DBEngine.OpenDatabase(DbFile, False, False)
    Dim rs As Recordset
    Dim WS As Workspace
    
    'Set workspace,database and recordset
    Set WS = DBEngine.Workspaces(0)
...