I have a access file, and need to create a view from VB6.
This isnt working:
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\SJA068.mdb;Persist Security Info=False"

sql = "CREATE VIEW DatosLiq(field1) AS "
sql = sql + "SELECT nov_det.ndet_impcal"
cn.Execute sql

The view I need to do has 30 fields, I use the code above as example.

That gives me an error in cn.execute sql
I read that with this method I cant create a view in access, but cant find the correct way to do this.
Thanks!