Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Communicate with access
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00972392
Message ID:
00972418
Views:
21
Hi Yuri,
Merry Christmas first and thanks for your answer.

Here is what I need to do:

I am using VisualCE to create an application on my DELL AXIM3 Pocket PC.
It can be syncronized with a text file which needs to sent to the PDA. The only way I know is physically dragging the file from the desktop to the PDA in windows explorer. This might be to difficult for users.
I don't know how to sned a file to a directory on the PDA from VFP(9).
The othe way is to use an access database then visualCE does the synching automatically.
For this to work I have to be able to open an access table and comparing it to my VFp table and adding records if needed updataing and so forth.

Istarted with and got stuck in lack of knowledge of access object model:
oAcc=create("access.application")

oAcc.OpenCurrentDatabase("C:\Program Files\Windows CE Services\SYWARE Visual CE\CPR\pac1.mdb")
oMDB=oAcc.CurrentDB
oRs=oMDB.OpenRecordSet("claims1")
do have any pointers or help?
P\
Thanks

Peter



>It depends on what do you mean, "communicate", and on your definition of "easiest way". Anyway you may start with the search here in the FAQ section for "access" or "MDB".
>
>>I need to communicate with Access in some way.
>>
>>what is the easiest way? and how?
>>
>>Peter
Peter Cortiel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform