Set oCacheConn = CreateObject("ADODB.Connection") cConnString = "Provider=VFPOLEDB.1;Data Source=v:\all1dbc.dbc" With oCacheConn .CursorLocation = 2 ' adUseServer .ConnectionString = cConnString .Open End With cExec = "Create View MyView1 as Select * from aiacode2" Set oCMD = CreateObject("ADODB.Command") oCMD.ActiveConnection = oCacheConn oCMD.CommandText = cExec oCMD.ExecuteHowever, I am still tripping on using parameterized views....