Thread: ADO Connection
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E AA2e72E is offline
external usenet poster
 
Posts: 400
Default ADO Connection

I forgot to mention another important downside of Late Binding: the
constants, like adOpenStatic, adOpenKeyset etc cannot be used unless you
assign them their corresponding values.

As well as MDAC2.8, you may want to download the SDK: it contains of several
help files that contain code for several languages including VB (VBA can just
use such code) AND you get the values of all the ADO constants.

PS: If you are using Options Explicit, you would

Dim rstData as Object