Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Des Moines, Iowa
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Add Data from a Palm (Access 97)

    I have a database with two tables. I want to be able to record data into a Palm then sync with the Access tables. I have a database of sorts on my palm, but the Access database is too complicated. I'm looking for a good piece of Palm-based software to feed this Access database. I'm posting here since I figured that you folks reading this would likely have done something like this before, and that most of those in the Palm forum wouldn't track with all the Access stuff. Can you help?

    I have a probably typical scenario where for one event there is some data that defines the event ( date, time, employee, etc) and multiple pieces of data that are associated with that event ( test given, results, notes, etc. ). I have one table, tblTestMaster, that has all of the defining data fields and one AutoNumber Key named TestEvent. The second table, tblTests, has the repetative data including the TestEvent number and an AutoNumber field that is the key. I have created a many-to-one relationship between tables on TestEvent where tblTests is the many side. Referential Integrity is enforced. The tblTests is fed by a subform of the main form such that the TestEvent number is fed to tblTests.

  2. #2
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Add Data from a Palm (Access 97)

    (Edited by HansV to remove space from URL and to make it clickable - see <!help=19>Help 19<!/help>)

    Check the HandBase site http://www.ddhsoftware.com/syncexchange_access.html. You can download a 30 day trial and see if it helps. I started doing something like this, and it worked OK. However, in the end the client seems to prefer Pocket PC and I am going to use a VB front end on Pocket PC, and forget about Palm

  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Des Moines, Iowa
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add Data from a Palm (Access 97)

    This, believe it or not, is just where I started since I had purchased HanDBase for my own uses. The difficulty is that I cannot use the Palm to generate autoID numbers since there would be a chance of duplication. I tried syncing only the remaining fields, but Access chokes on that and generates an error. For what it's worth the error is from the process hdeaccess.exe. The message says that an error log is being created, but I don't know where it might be. It doesn't show up in Event Viewer.

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add Data from a Palm (Access 97)

    Dean

    Can you give us an update on your HanDBase application?

    Thanks, John

  5. #5
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Des Moines, Iowa
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add Data from a Palm (Access 97)

    Wow, this was from a *very* long time ago.

    I never did solve the problem. The powers that be in the company had decided they didn't want to follow through, so the problem went unsolved.

Posting Permissions

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