The first problem I have to fix is that I do not know how to match "username and password" typed in the form with the relate data in the Access table. I used the codes as following,

Open "db1.mdb" For Input As #1 Len = Len(mudtmemberRecord)
Get #1, intNumber, mudtmemberRecord

Also, I am not sure whether I need to define an array like,

Private Type Memberstructure
strUname As String
strPassword As String
End Type
Dim mudtmemberRecord As Memberstructure

Then I can use array to match each other.
I know something must be wrong, can you tell me