Pamela

>>The VFP OLEDB Provider doesn't appear to support the ADO Parameter object. It does support VFP syntax in the command object, however. Rather than use a view, can't you use the view's SQL statement and filter the RecordSet through the command object or the RecordSet.Open() statement?

Thanks for the swift response.

I'm new to VS.Net et al, so I assume what you are saying is that I need to use the ADOCommand class and create a DataReader rather than a Dataset ?
I'll have a look at this tomorrow and see how I get on - thanks for pointing me in the right direction.

Anna