>>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?
Did you create a connection in the DBC to this data source? To be able to send updates, you have to identify the Key and Updatable fields in the view designer under the Update Criteria tab.
Mark McCasland
Midlothian, TX USA