Hi All,

I’m trying to get connected to VFP6 backend database using VBA. I used a Udl file to build the connection string and tested it over and over. Everything worked OK there. When I pasted the same connection string in my VBA code I get an error message saying

“Object Variable Or with Block Not Set..”

What does this mean ?? How do I correct it ?

My VBA Code..

*---------------------------------------------

Dim M2MConnect As ADODB.Connection

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

*------------------------------------

Please HELP !!!

TIA

- Jeana -