ADO events under Access 97

  • Thread starter Thread starter Archives
  • Start date Start date
A

Archives

Hello,

Does anybody know how to use an ADO event under Access 97 ?

Since, we can't use the Enum type under Access 97, I try to replace
ADODB.EventStatusEnum by a Long type. So, I have this code:

Private Sub connEvent_ConnectComplete(ByVal pError As ADODB.Error, _
adStatus As Long, _
ByVal pConnection As ADODB.Connection)

But I get an error at the compilation. I checked this code under Access 2003
and all was fine.

Do you know how to code this event under Access 97 ?
 
Yes I did (version 2.7). All the ADO methods and properties are OK. I can
connect a database, read some recordset but I can't compile an event.
 
probably you have different ADO versions?

to make sure you insert correct proc declaration - use 2 top combos of class
module window to add proc
 
I have tryed to use the two top combos. When I select an event in the right
combo, it creates all the event but with the sub line in red. It is because
it uses "ByVal pConnection As ADODB._Connection" as last parameter instead
of "ByVal pConnection As ADODB.Connection".

When I remove the "_", I get a black line but I can't compile. Always the
same warning message.

I have tryed with version from 2.0 to 2.7 without result.
 
Back
Top