USE [Users_mdb]
GO
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[Supplier]'))
DROP VIEW [dbo].[Supplier]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[Supplier]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[Supplier]
AS
SELECT     [nID], [tName], [tEmailName]
FROM         [Users_mdb].[dbo].[tblUser]
WHERE     ([nID] > 0 AND [tName] <> '''' AND Security_Type = 9 OR  Security_Type = 4)
' 
GO
