I have a vb function who create view
Public Function NewQuery(QuerName As String, sqltext As String)
On Error Resume Next
DoCmd.DeleteObject acServerView, QuerName
On Error GoTo 0 'Delete if exists
strProc = "Create View " & QuerName & " as " & _
Left(sqltext, Len(sqltext) - 1)
But when the view is first created, second time that I recreate with the same name I have a "There's an object already named...."
The DoCmd.DeleteObject don't delete the view.
There's a kind of refresh needed.
Someanoe know how to refresh the list?