I have VB6PE and Access 97. I used VB's wizard to create my form for me. When I went to run the following code, it gave me an error: "Compile Error: Invalid Use of New keyword". Is this a glitch/bug? Am I missing a DLL/reference?

Dim sSQL As String
Dim dfwConn As ADODB.Connection
Dim i As Integer
Dim j As Integer
Dim m_iMaxCol As Integer

' set strings
sConnect = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;User ID=Admin;Data Source=H:\DTC\UnAffirm\unaffirm.mdb;Mode=Share Deny None;Extended Properties=';COUNTRY=0;CP=1252;LANGID=0x0409';Jet OLEDB:System database='';Jet OLEDB:Registry Path='';Jet OLEDBatabase Password='';Jet OLEDB:Global Partial Bulk Ops=2"
sSQL = "select Affirm,Rec_Type,AffirmNum from tblEquity Order by AffirmNum"

' open connection
Set dfwConn = New Connection
dfwConn.Open sConnect

The error highlights the Set dfwConn line. Thanks for any help.
Wendy


Wendy