M
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.
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.