Results 1 to 6 of 6
  1. #1
    DaveShmave
    Guest

    Access DB and PDA's

    Hi,

    Is there a good place to go and research information on trying to incorporate (synchronizing data) an Access database and say a Palm Pilot, Pocket PC, etc.?

    What are the limitations, storage capacities, pitfalls, etc.? Is the technology advanced enough to use a PDA and a large networked Access database?

    I went to the Palm web site but it didn't answer many of my questions.

    Anyone have experience in this area and can shed some light on this?

    TIA

    Dave <img src=/S/nuts.gif border=0 width=15 height=15>

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access DB and PDA's

    Dear Dave,

    I am very interested in linking Access data to a Palm, and its been done by at least two companies. I found it very easy to develop a DB on a Pilot with HandBase and I believe this can that be linked to an Access DB, although I didn

  3. #3
    DaveShmave
    Guest

    Re: Access DB and PDA's

    Thanks for the feedback on this and the Palm forum.

    I'll print this out and read over it. I've been very swamped recently so haven't had a chance until now to check back.

    Thanks again,

    Dave

  4. #4
    New Lounger
    Join Date
    Mar 2001
    Location
    Washington DC suburbs
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access DB and PDA's

    Hi Dave!

    Sorry to get to this old thread at this point, but today is my first day at this site. I purchased DbX and found it to be somewhat of a cumbersome and really not needed if you convert the .pdb / .csv files into Excel files and upload such into Access.

    I've been studying this Access to Palm and vice versa issue for the longest time and one nite several weeks ago actually ended up downloading inadvertently the .ocx drivers needed to do the synchronization process right from Access itself (ie you can bypass the Excel file or text delineated file route)! I cannot attach it to this letter, as the zip file still comes out at 147kb (ie there is a 100kb limit in this forum). Anyone interested can email me for a copy.

    Regards, Al.

  5. #5
    New Lounger
    Join Date
    Mar 2001
    Location
    Washington DC suburbs
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access DB and PDA's

    A couple of folks have written to me asking for the .ocx information. Here's the scoop on where this issue stands right now (copy of private letter to Bob) for those interested:
    ________________
    "R. R. Mellott" <RMellott@kc.rr.com> wrote:

    Saw your post. I have an Access program that needs portions to be sent to Palm-type PDA's. Any help or guidance you can give will be most sincerely appreciated.
    Thanks
    Bob
    -------------------------------------------
    Hi Bob:

    I've been literally striving over this for the past week. Unfortunately, the .ocx driver that I posted on Woodies doesn't seem to work, and emails to the author have been ignored. The good news is that you have 3 choices now! Here they are:

    1) Go directly to Pendragon Forms-- this is probably the best route, as the 3.1 version can directly interact (ie LINK!!!) with MS Access tables which surely beats having to download your Palm information into a conduit table then relay it to MS Access (seen in Satellite Forms and in HanDBase as well as in all other programs). Pendragon Forms is costly, but a 1 user license costs you $99 still if you buy their $15-$30 (depending on what you can find in Amazon or eBay) introductory book which has a $50 off coupon. The runtime toolbox is expensive- $849 if you upgrade from your single user license, almost $1000 if you buy it directly.

    2) use the RickPalmDB.ocx code made by "Rick" which can be downloaded at the NS Basic for the Palm OS site; although it was intended to be used with this good cheap alternative VB editing software for the Palm, it can be used with any software platform inside MS Access. Unfortunately, unlike Pendragon Forms, NS Basic's new 2.0 version software does not directly link MS Access tables to the Palm tables (without synching). Download his software from:

    http://www.nsbasic.com/palm/support/downloads.html

    This .ocx code does come with a text document that describes how to active the conversion from the Palm database format directly into a *.mdb table.

    The NS Basic's $99 runtime edition cost is really a steal, though!

    3) Buy the 5/2001 edition of the magazine Access/VB Advisor- it has a ***BIG*** section on Palm and Pocket PC software. For instance- did you know that Microsoft is giving away the new Visual Basic 3.0 software for the Pocket PC?? They have one article almost exclusively on this (they did away with their C++ toolkit and now MS prefers to make VB their language of choice). Almost makes one want to change formats! Also they give the .cvs to .mdb code that you need to import Palm databases without to go the *.ocx route.

    Lastly, for those who wish to download the *.ocx file found at HanDBase's website (ie the one that I couldn't get to work), go to:
    http://www.handbase.com/knowledgebase.html?read=69
    (please let me know if you can get it to work!)

    That's it! I'll try to post this on Woodie's website as well so that others can see this new stuff...

    Regards,

    Al

  6. #6
    DaveShmave
    Guest

    Re: Access DB and PDA's

    Thanks I'll check all of this out.

    Dave <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •