set cnNorthwind = new adodb.connection doesn't work either because then my next line "cnNorthwind.CursorLocation=adUseClient" gives invalid data or member. The code should work as is, this is how my instructor gave it to me.