Geoff,
Check out the MM .NET Developer's Guide Help topics:
Does the VFP OLE DB Provider work with free tables?
Does the VFP OLE DB Provider work with views?
These are found in the "Data Access FAQs" section of Chapter 4.
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com