Using ADO Connection
Using ADO Connection is more faster than using DAO.
Here is a sample of password checking using ADO for your reference.
Private Sub cmdOK_Click()
CurUser = UCase(Me.txtUserName)
rs.Open "Select * from User_SecurityInfo where UserID= '" & CurUser & "'", db...
I suggest not to put the image file inside the Database instead put it on the other folder and instead of using OLE field use image and point the path to the location of pictures. because storing pictures on MS Access database it will make your MDB file big enough to crash the database.