Restricting cols with a data view

G

Guest

Hi,

I've always used Database views to restrict columns from the user. Is this
what ADO Dataviews are also meant for? I see how you can filter rows with a
data view, but how about columns? Can this be done with a dataview? Is there
a better mechanism to do this with?

Thanks for any ideas in advance.
Ant
 
C

Cor Ligthert [MVP]

Ant,

You can do that in version 2005 with the overloaded function
dataview.totable. In earlier versions you have to do that in a loop.

I hope this helps,

Cor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Binding to two dataviews 3
Can I access rows & cols with a data source 3
Iterating through the rows of a dataview 1
No DataView column filtering: design weakness? 3
Using DataView.RowFilter with DateTimes including both date and time data 1
Converting between RowViews & Rows 2
Access stripping decimal places in query 1
Displaying/Modifying Multiple Tables as One Table 2

Top