Set oCacheConn = CreateObject("ADODB.Connection") cConnString = "Provider=VFPOLEDB.1;Data Source=v:\db\alldbc1.dbc" With oCacheConn .CursorLocation = 2 ' adUseServer .ConnectionString = cConnString .Open End With cExec = "Create View zview04 as Select * from aiacode2 Where cClaimType = ?cClaimTypeWanted" 'This gives an error about not enough parameters 'However making the view not parameterized works, 'But I need a parameterized view ' Set oCMD = CreateObject("ADODB.Command") ' oCMD.ActiveConnection = oCacheConn ' oCMD.CommandText = cExec ' oCMD.Execute 'This gives no error, but cannot re-run script because "DBID already exists" 'But the view does not show in the VFP7 IDE either Set oCMD = CreateObject("ADODB.Command") Set oCatalog = CreateObject("ADOX.Catalog") oCatalog.ActiveConnection = oCacheConn oCMD.CommandText = cExec oCatalog.Views.Append "zview04" , oCMDWhat about using a stored procedure in the DBC, and through my ASP page accessing the SP and getting back an array or recordset? Have you ever done that?