Sql Count

[Simply Me]

Im guessing right now as i am reading a book while we talked. I call my this first

Public Sub openConnection()
  Set oConn = New ADODB.Connection
 
  With oConn
    .Provider = "SQLOLEDB"
    .CursorLocation = adUseClient
    .Properties("Data Source").Value = ".\SQLEXPRESS"
    .Properties("Initial Catalog").Value = "MasterFile"
    .Properties("Integrated Security").Value = "SSPI"
    .CursorLocation = adUseClient
'    .Mode = adModeReadWrite
    .Open
  End With
End Sub

then i got to have something like this cmd.Commandtype=adCMDStoredProc