General information
Category:
Database DAO/RDO/ODBC/ADO
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only