Create hetrogeneous view from VB Code

[Mark Neilson]

I am trying to create a view that contains OPENROWSET using VBA. The
datasource is a jet 4.0 database

Trying ADOX using the Views.Append method, I get the error message that the
"object or provider is not capable of providing the requested operation"

I have tried using MSDSQL as well as native driver for SQL (although "views"
are not supported using the SQL driver).

I have also tried using SQLDMO Databases.Views.Add method. This works OK
for regular views but returns the error message "...must set ANSI_NULLs and
ANSI_WARNINGS on for hetrogeneous queries.

Are there any other options for creating a hetrogeneous object that can be
manipulated in SQL from VB Code? I am writing Access data project andfthe
client requires tha ability to manipulate data from access.

 

[Tibor Karaszi]

Why not quite simply execute the CREATE VIEW command (with needed SET
options first)?