Access Fields in a View

[DeanWilliams]

Hi,

Is there any way to access the fields in a view in an Access project? What I mean is, is there an equivalent of DAO QueryDefs for Views? I want to enumerate and change the field names specified for a view in code.

The AccessObjects in the AllViews collection doesn't allow access to the fields.

Any help would be great.

Thanks in advance.

Dean

 

[cmmrfrds]

That should be done in conjunction with the DBA on the sql server side. Either through Query Analyzer or Enterprise Manager. I suppose you could do it through DDL statements but that seems cumbersome and probably unnecessary, but the DBA would need to grant permissions for this.

 

[yaya013]

strSQL = "SELECT * FROM MyTable "
CurrentProject.Connection.Execute "ALTER VIEW MyView AS " & strSQL