Hi I use VB 6.o as my front end... execute a query in Access... by the following code
sQueryName = "[Warranty Update 12 Month Rolling #2]"
adocmd.CommandText = sQueryName
adocmd.CommandType = adCmdStoredProc
adocmd.ActiveConnection = conAdo
adocmd.CommandTimeout = 1200
adocmd.Execute
I wanted to retrieve the record count that is affected ....
can anyone suggest me the syntax