Thank you very much.
Eric, I have another issue, hope you don't mind.
With AdodcAddRec
With .Recordset
.AddNew
!Index = "A"
!Name = "Alvin"
!Address1 = "29 Senoko Way, Singapore 123456"
End With
End With

I hit with error while the program write into the Table.
The problem lies in the "Comma" in the Address1 field.
If I take out the "Comma" then the record will be created in the
Table. What actually went wrong, I can input the "Comma" in an
Access environment and why not in the VB program? Pls help me.


>>Also, how to issue this "Database Password" programmatically? Any sample
>>code to share? Once again, thank you.
>
>This is the syntax for your connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Projets VB\NWIND.MDB;Persist Security Info=False;Jet OLEDB:Database Password=test