Create view from ADO.NET in Access problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have got the following problem: i try to create a view (query) in MS Access through ADO.NET with the oledb Jet provider, i use the following code
dbCommand.CommandText = queryString
dbCommand.CommandType = CommandType.Text
dbCommand.ExecuteNonQuery()

This creates the query that i specify in the queryString, the problem is that it doesn't show up in the query tab in Access, if i use the query in another query (from Access) it works just fine
I have already checked the option to show hidden objects but that doesn't solve the problem, if i look in the Msysobjects table i can see the name of the query and other queries, but the query i created does have a different value in the flags column
Is there a way to set the flags from ADO.NET or an parameter for the dbCommand so that it creates an normal query

Thanks in advanc
Jelle Buinin
Netherlands
 
Back
Top