I am using VFP 6.0, SP3. In the last 5 minutes, I was able to use VFP's Remote View wizard (Tools - Wizards - Queries from the menu) to create a remote view of the Customers table in the Northwind database, which ships with Access 2000 (and previous versions of Access).

After creating the remote view, called vCustomers, I able to:

USE vCustomers

and treat the view just like a VFP table.

>Ok, my last thread got me nowhere and it seems that no else is getting anywhere with this topic, BUT I need specific examples and I don't need links to Microsoft's ADO site. I know you all are very smart and probably have done something like this. I feel like I can't grasp the meaning of the web sites and/or any documentation I try to find on this subject. Nothing goes into detail.
>
>I am trying to open an access database in VFP 6.0 (C:\GE DESKTOP EDI\EdiPC2). The actual table within the database is called Docfl. I need to select all the records and save them into a new foxpro database. This all needs to be done automatically through VFP not done through ACCESS. This can be done easily, can't it?
>
>Thanks for all your help.