Writing to Access DB

[Jonny1409]

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

My code is as follows:

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,

[Siddharth Rout]

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

[Hack]

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

[Condomx]

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

[si_the_geek]

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

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.