What DB tool for a pocket pc

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

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.

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

Reply | Quote