Hi Sherry,

Do the following:

1 - Create your connection ODBC;
Steps: START; CONTROL PANEL; DATASOURCES(ODBC) and at the second page, create your own SystemDSN connection. This means you are creating a connection to Access, that is available for everyone who works with the machine which has it. Give a name to the datasource(example: "MyAccessDSN") and choose Access database.
2 - At Visual Fox, create a connection(example: "MyAccessConn") for your database. Just for checking, create the connection "visually". When VFP ask for the datasource, choose "MyAccessDSN". Click OK!
3 - Just for checking, create("visually") a remote view! VFP will ask for the connection and you choose "MyAccessConn". If you do "Add table" you will have the Access tables in front of you.

I said to create visually, but i normally do it by code. If you need the syntax, just say it, but i think you've already understand. Don't forget: create the DSN, create the connection to your database, and... you're on your own :)

Good luck,

Ricardo