Writing to Access DB

I'm trying to write some fields into a table in an Access DB and am having a problem.

My code is as follows:

Code:

---

Dim cn As adodb.Connection
Dim rs As adodb.Recordset
Dim cString As String
cString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=ABC.mdb;Persist Security Info=False;"
 
Set cn = New adodb.Connection
cn.Open cString
Set rs = New adodb.Recordset

With rs
    .Open "tbl_ABC", cn, adOpenKeyset, adLockOptimistic
    .AddNew
    .Fields("Field1").Value = "Test"
    .Fields("Field2").Value = Now()
    .Fields("Field3").Value = "abcdefghijklm.xls"
    .Update
    .Close
End With

---

For some reason it is failing on the "Field3" line with an error number -2147418105.

Can anyone help identify what I'm doing wrong ?

Thanks,

1) What is the type of the field?
2) What is the max size of that field?
3) Also check if you have spelled the field correctly

Also, what is the verbage of the error message? What is it telling you?

it is because you are calling a field that have "." sequence and that is in under "" which read as a statement..

Thread moved to 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums)

Quote:

---

Originally Posted by Condomx

it is because you are calling a field that have "." sequence and that is in under "" which read as a statement..

---

I don't know what you meant by that, but after comparing it to the code in post #1, I'm as sure as I can be that you are not correct.