>If this is going to be an Access table that others will use from Access and
>you need to use it from VFP, you can create a remote view of the Access table
>using ODBC. You can make this view updatable and retrieve data from Access and
>send back updates and new records with little or no problems.

This is a nice idea, but it is not working.

I do not appear to have to option of making it updatable, or at least I cannot find it. The box entitled "Send SQL Updates" is disabled. Also, I need to delete records as well as add them.

Plus, it prompts for the location of the mdb file every time I open the view and refuses to save the information. This is not usable.

Am I missing something?