Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Manchester, Gtr Manchester, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Some colleagues at work want to start using pocket pc's to collect data. I'm aware there is no 'pocket Access.'

    I've been reading about a product called HanDBase which might do the trick but it seems to be limited to 100 fields. Unfortunately our survey questionaire has more than this!

    I don't have (and am unlikely to get) a proper copy of Visual Studio (not the Express versions) which I understand is necessary for compact development. That aside I think I'd find developing with Visual Studio pretty intimidating anyway.

    I know this isn't really the right forum but I'm guessing some of you Access guys have found yourself in a similar situation.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    If you mean that your questionnaire has more than 100 questions, you might consider a design where each reply is a separate record in a subtable instead of a field in the main table. The subtable would have only a few fields, for example RespondentID, QuestionID, AnswerNumber, AnswerText.

    I have no experience with databases on handheld devices, but others I've seen mentioned are SprintDB and DB Anywhere.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Manchester, Gtr Manchester, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='775717' date='18-May-2009 16:27']If you mean that your questionnaire has more than 100 questions, you might consider a design where each reply is a separate record in a subtable instead of a field in the main table. The subtable would have only a few fields, for example RespondentID, QuestionID, AnswerNumber, AnswerText.

    I have no experience with databases on handheld devices, but others I've seen mentioned are SprintDB and DB Anywhere.[/quote]


    It's a horrible questionaire (well, a very detailed geomorphology survey) with lots of 'tick all that apply' type checkboxes and has question for both the left hand side and right hand side of a river. In reality I guess the table could be broken down into chunks by theme (a combination of a fair few one-to-one related tables and some one-to-many). Trouble is, I can deal with all that in Access, just not sure how well I could manage it in something else.

    Thanks for the links

Posting Permissions

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