Hi Jeana

You will need to set the object. Before open the connection you will need set it before

Dim M2MConnect As ADODB.Connection

set M2MConnect = new ADODB.Connection '<===============Add this

M2MConnect.Open "Driver={Microsoft Visual FoxPro Driver};" _
& "UID=;PWD=;SourceDB=R:\M2Mdata\DATA10\M2MDATA.DBC;" _
& "SourceType=DBC;Exclusive=No;"

this should work

Efrain