Maybe you guys can help me....
I have a program that uses Access as its data storage medium. I have recently made some changes to the core program that require an alteration to some of the queries/views in Access as well as some new tables. I have therefore constructed a routine that checks the database to see if the tables exist and creates them if they are absent - all through ADO.NET and standard SQL queries (DROP Table, Create Table , Alter Table etc). This all works great with no problem.
The problem lies when I try to amend one of the queries in Access. I can get the query to drop by doing the DROP Table SQL statement, but the standard SQL call of Create View .... doesnt work properly (well it does, but not what I want!)
So, enter ADOX stage right. I can connect okay using ADOX.ActiveConnection = Connstring but when I try and call the ADOX.Views.Append ("tblName",SQLstring as a OledbCommand.CommandText object) it comes back with an error saying the Interface is not supported.
Does anyone know of a way to create views in Access through VB.Net/ADO.NEt (preferably without having to use ADODB if possible).
MSDE is not really an option as some of the users are completely IT illiterate and we have had enough trouble getting them to install the program in the first place even although it uses a bog-standard setup program, so the thought of trying to get them to install MSDE fills me with dread!
Any thoughts appreciated.
Regards
Iain D
I have a program that uses Access as its data storage medium. I have recently made some changes to the core program that require an alteration to some of the queries/views in Access as well as some new tables. I have therefore constructed a routine that checks the database to see if the tables exist and creates them if they are absent - all through ADO.NET and standard SQL queries (DROP Table, Create Table , Alter Table etc). This all works great with no problem.
The problem lies when I try to amend one of the queries in Access. I can get the query to drop by doing the DROP Table SQL statement, but the standard SQL call of Create View .... doesnt work properly (well it does, but not what I want!)
So, enter ADOX stage right. I can connect okay using ADOX.ActiveConnection = Connstring but when I try and call the ADOX.Views.Append ("tblName",SQLstring as a OledbCommand.CommandText object) it comes back with an error saying the Interface is not supported.
Does anyone know of a way to create views in Access through VB.Net/ADO.NEt (preferably without having to use ADODB if possible).
MSDE is not really an option as some of the users are completely IT illiterate and we have had enough trouble getting them to install the program in the first place even although it uses a bog-standard setup program, so the thought of trying to get them to install MSDE fills me with dread!
Any thoughts appreciated.
Regards
Iain D