Run time error 3251

[kazper]

Good day,
I hope you guys could help me do something about this problem, it seems like I forgot the right codes to use :D

Dim adoRS as new ADODB.Connection
Dim recRS as Recordset


adoRS.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=User;Initial Catalog=Dbase;Data Source=DBase", "user", "Password"
Set recRS = adoRS.Execute("select * from TableName")

But when I try to update the table. It returns an error 3251

Hope you guys could help me out on this problem

TIA

[hariharanmca]

Good day,
I hope you guys could help me do something about this problem, it seems like I forgot the right codes to use :D

Dim adoRS as new ADODB.Connection
Dim recRS as Recordset


adoRS.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=User;Initial Catalog=Dbase;Data Source=DBase", "user", "Password"
Set recRS = adoRS.Execute("select * from TableName")

But when I try to update the table. It returns an error 3251

Hope you guys could help me out on this problem

TIA

Run-time error '3251'

i think this will help you

[fplesco]

Good day,
I hope you guys could help me do something about this problem, it seems like I forgot the right codes to use :D

Dim adoRS as new ADODB.Connection
Dim recRS as Recordset


adoRS.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=User;Initial Catalog=Dbase;Data Source=DBase", "user", "Password"
Set recRS = adoRS.Execute("select * from TableName")

But when I try to update the table. It returns an error 3251

Hope you guys could help me out on this problem

TIA

Hello kazper -

This could be your problem

Dim adoRS as new ADODB.Connection
Dim recRS as Recordset
 

Change the latter declaration to

Dim recRS As ADODB.Recordset
 

I hope this would solve your issue.

Godspeed...