Private mrsCon as ADODB.Recordset Set mrsCon = New ADODB.RecordsetAlso, make sure that your reference is turned on for ADO and turned off for DAO. If you have both loaded (and I do have a project that uses both DAO and ADO) you have to be explicit with the Object name or the app can get confused. Aadditionally, you should avoid using New for instatiation an use CreateObject instaed as .NET does not support the New instatiation and porting your code later on will be easier if you use CreateObject