>Hello All,
>
>I need some ideas on something. I have a need to share data between an ACCESS97 .MDB and a VFP 5.0a DBC. Specifically, I need to be able to read *AND* update the Access MDB tables from within my VFP app.
>
>Any ideas? I have a lot of VFP experience, but have limited Access. So far, I can access(forgive the pun) the MDB through ODBC, but haven't been able to update anything. In Access, I can link the VFP tables (yes it can be done to VFP 5.0, but you have to *NOT* include the indexes), but don't know what to do after that, as I am Access Macro challenged.
>
>I would like to accomplish this from VFP. H*E*L*P !
>
>Phillip Grant
>pgrant@aeneas.net

Remore view based on ODBC-Access source will update Access table without problems (just remember to make the view updatable).