You'll need to use ODBC. To do this, go to the control panel and run the ODBC panel. Create an ODBC data source using the Access driver. You can then create a connection in your database to the Access database. This will allow you to create remote views against Access tables or to use SQL pass-through (using SQLCONNECT() and SQLEXEC()). You can get more information in the VFP Developer's Guide. There's a chapter on accessing remote data, or something like that.

>Is there a way to open an Access97 table in VFP?
>
>Eric K.