Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Interfacing VFP 5.0a and MS Access
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00128873
Message ID:
00128882
Views:
15
>>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.com
BrainBench Certified: Visual FoxPro, RDBMS Concepts
Previous
Reply
Map
View

Click here to load this message in the networking platform