Thanks for that point Allan but how come my Execute Statement Fails to Set @ErrorsExist When errors do exist ?

Thanks

Andy

Steve

Thanks for your suggestion. Unfortunatly I still can't resolve the problem could you please give me a further example of the syntax I should use just in case I'm getting...

Code as Requested

' SQL DMO Variables

Private oSQLServer As SQLDMO.SQLServer

Private oFormsDB As SQLDMO.Database

Private oFormsTable As SQLDMO.Table

' SQL Namespace Variables

Private oSQLNameSpaceObject As SQLNamespaceObject

Private oSQLNameSpace As SQLNamespace

Private NameSpaceArray(10) As Long

'Calls various routines from...