Setup: NT, Access97, ADO2.6
I'm trying to use the ADO Events on the connection object (declared using the WithEvents Keyword)
My dilemma: when I properly declare an event such as...
Private Sub Con_Disconnect(adStatus As ADODB.EventStatusEnum, pConnection As ADODB.Connection)
I get an error "Type not supported in Visual Basic"
on the other side, when I try to change the event declaration to a LONG data type instad of the EventStatusEnum (which I know is not supported in access 97), I get the error "Event procedure declaration doesn't match description of event having same name"
is there a workaround, or is it just not possible to use events that contain enumerated parameters in A97?