Set oCacheConn = CreateObject("ADODB.Connection") cConnString = "Provider=VFPOLEDB.1;Data Source=v:\remote1\db\alldbc1.dbc" With oCacheConn .CursorLocation = 2 ' adUseServer .ConnectionString = cConnString .Open End With cExec = "Create View View01 as Select * from alldbc1!accidentstate Top 1" oCacheConn.Execute(cExec)Error is