>>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).
Ed, Mr. Pikman, you are a god among men. Thank you. I was looking in the wrong place in the remote view, and it took another Foxer to "slap-me-upside-the-head". This simplifies everything. Thanks again. If I can return the favor, don't hesitate...
Phillip Grant
pgrant@aeneas.net
"When all else is said and done, more is usually said than done..."
Phillip Grant
Grant Computer Consulting
731.642.2162
phillip@grantcomputer.comBrainBench Certified: Visual FoxPro, RDBMS Concepts