>Thanks, I'm glad to learn about the execute immediate function. However, I added the following line just after the loSqlServer create statement and I still get the same error.
>
>loSQLServer.ExecuteImmediate('SET QUOTED_IDENTIFIER OFF')
>loSQLServer.ExecuteImmediate('SET ANSI_WARNINGS ON')
>loSQLServer.ExecuteImmediate('SET ANSI_NULLS ON')
>
>Any ideas? TIA.

After? These need to be set before the command that creates the view. One other thing you might want to look at is the AnsiNulls property (or something like that) on the SQLServer object.