Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How do I install MS Access on my iPAQ Pocket PC

Discussion in 'Information Technology' started by Eric, Nov 17, 2005.

  1. Eric

    Eric
    Expand Collapse
    Guest

    I would like to use a couple of Access programs on my PDA but can't find a
    usable program that's simple. Anyone have a suggestion?
     
  2. Loading...


  3. Kyle

    Kyle
    Expand Collapse
    Guest

    I don't personally use Access databases on my iPaq (I prefer ListPro
    for my simple needs), but associates of mine highly recommend HanDBase
    from DDH Software (http://www.ddhsoftware.com/). Another highly
    recommended application is Pocket Innovations' Pocket Database
    (http://pocketdb.pocket-innovations.com/).

    Other apps tend towards the extremes: either very complicated unless
    you're a programmer (like MS's SQL Server 2000 Windows CE edition) or
    so stripped down as to be too simple to use.
     
  4. Eric

    Eric
    Expand Collapse
    Guest

    Thanks Kyle. Unfortunately, I'm not a programmer and I've tried the HanDBase
    software but it wouldn't recognize the file unless I converted it. Then it
    did some other funny stuff. The end result was not good, so I turned to this
    listserve for help.

    "Kyle" wrote:

    > I don't personally use Access databases on my iPaq (I prefer ListPro
    > for my simple needs), but associates of mine highly recommend HanDBase
    > from DDH Software (http://www.ddhsoftware.com/). Another highly
    > recommended application is Pocket Innovations' Pocket Database
    > (http://pocketdb.pocket-innovations.com/).
    >
    > Other apps tend towards the extremes: either very complicated unless
    > you're a programmer (like MS's SQL Server 2000 Windows CE edition) or
    > so stripped down as to be too simple to use.
    >
    >
     
  5. Kyle

    Kyle
    Expand Collapse
    Guest

    Eric,

    Does the database have to stay in Access (for example, is this
    something from work and they use only Access?) Do you just need to look
    at the database on your iPaq, or need to be able to update it and then
    pass those updates back to the original database on the pee-cee? Are
    you married to the idea of keeping the interface of the Access
    database?

    The reason I ask is another option might be to export the database as a
    set of tables or even tab-delimited files, then import them into a
    PocketPC database program and build a new UI for the data (like forms
    and reports in Access).

    Also, some PocketPC database programs out there will come with a
    desktop interface, so you could port the database entirely over to the
    PocketPC application and use the desktop interface for your PC work, as
    opposed to Access.

    Another option might be to see about porting the database over to Open
    Office's BASE? From the OpenOffice.org website: "BASE includes a full
    version of the HSQL database engine, storing data in XML files. It can
    also access dBASE files natively for simple database work. For more
    advanced requirements, BASE supports many popular databases database
    natively (Adabas D, ADO, Microsoft Access, MySQL), or any database
    through industry-standard ODBC and JDBC drivers. It also supports any
    LDAP compliant address book, as well as common formats such as
    Microsoft Outlook, Microsoft Windows, and Mozilla."

    Just a couple of thoughts from someone who's found Access to be a bit
    too kludge-y for my purposes. (I keep this up and I'm gonna end up a
    Mac user eventually...!)
     
  6. Eric

    Eric
    Expand Collapse
    Guest

    Kyle,
    That's exactly the case. I wrote a medical charting (Access) program for
    work, and I'd like for the staff to be able to document on a PDA and then
    download to the desktop computer.
    Eric

    "Kyle" wrote:

    > Eric,
    >
    > Does the database have to stay in Access (for example, is this
    > something from work and they use only Access?) Do you just need to look
    > at the database on your iPaq, or need to be able to update it and then
    > pass those updates back to the original database on the pee-cee? Are
    > you married to the idea of keeping the interface of the Access
    > database?
    >
    > The reason I ask is another option might be to export the database as a
    > set of tables or even tab-delimited files, then import them into a
    > PocketPC database program and build a new UI for the data (like forms
    > and reports in Access).
    >
    > Also, some PocketPC database programs out there will come with a
    > desktop interface, so you could port the database entirely over to the
    > PocketPC application and use the desktop interface for your PC work, as
    > opposed to Access.
    >
    > Another option might be to see about porting the database over to Open
    > Office's BASE? From the OpenOffice.org website: "BASE includes a full
    > version of the HSQL database engine, storing data in XML files. It can
    > also access dBASE files natively for simple database work. For more
    > advanced requirements, BASE supports many popular databases database
    > natively (Adabas D, ADO, Microsoft Access, MySQL), or any database
    > through industry-standard ODBC and JDBC drivers. It also supports any
    > LDAP compliant address book, as well as common formats such as
    > Microsoft Outlook, Microsoft Windows, and Mozilla."
    >
    > Just a couple of thoughts from someone who's found Access to be a bit
    > too kludge-y for my purposes. (I keep this up and I'm gonna end up a
    > Mac user eventually...!)
    >
    >
     

Share This Page