2nd request ..what is the best program to use with a PDA /Pocket Pc?

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I have seen a few out there, pendragon, HandDbase ,SprintDB Pro a few
others. I have
never used a pda before and have to make some forms to be used to update the
database from the work floor. Anyone have experience with the above or can
suggest others?
thank you
Michael
 
It depends upon the PDA as much as the program. I've successfully used
HanDBase and Pendragon Forms with the PocketPC. Of the 2, I prefer
Pendragon, although HanDBase has just come out with a new version that I
haven't seen yet. None of them have the power and/or ease of use of an
Access database running on a TabletPC (which is what I now use).
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
This question is about making forms in Microsoft access. I want to make
forms in the pda to update the access database where a computer cannot be
used. I am looking for someone who has used one of these programs to update
the database. This question is the same as one that would ask how to use a
barcode scanner to input data into the database.

Michael
 
Thanks Arvin,
Can you tell me how large and robust a TabletPC is? The user will be workers
who drive fork trucks for loading trucks, so it would have to be able to
take a little abuse.

I have never worked with any of these and I can buy what ever will preform
best.

I have a wifi network or I can use bluetooth or have them place the pocket
pc back in the cradle.
Thank you
Michael
 
You can Google this newsgroup..and get a good number of responses....

I used both pendragon and HandDbase.

It also depends on what platform you plan to adopt. So, if you have a bunch
of palm based units, then likely that is what you would continue to use.

Learning a new platform is a big investment of time...so, I would use what
you use now...not change on a whim...... (it can take years to really lean
windows, or whatever platform you choose).

pendragon is more tightly integrated with ms-access then is handdbase.

My only complaint about pendragon and handdbase is that they only support
low res screens (320x320) or (160x160). Many new palm units have a higher
res screen, 480x320.

DataViz products do support the hi-res mode of the palm. I use their Excel
viewer, and support of the hi-res makes a LARGE difference in the amount of
data that you can display on a screen.

I would also start reading some articles like the "zen of palm". The
lesson(s) you learn is that the pda is a very poor data entry tool if there
is to be any large amount of text entered. (so, you have to make lots of
easy to use check boxes, or easy to select combo boxes in the
application....writing is slow, and painful - applications that requite lots
of text entry are doomed to failure). So, learning what works, and what does
not will apply to ANY software system your use for a pda.. However, your
approach to application design for a pda has to CHANGE much...

So, just saying I want to build some forms on a pda might be the wrong
approach. Applications that display data, or allow something to be looked up
work well....but data entry of forms must be REALLY REALLY optimized for the
fewest number of steps possible.

Often, of small lists, people simply put the list in Excel...and use one of
many excel viewers on their pda.

As for cost...I recall that Pendragon was quite affordable. The most
expensive one (and one that has events similar to ms-access) is of course is
Satellite Forms. They were owned by Intellisync, but the company was
purchased by Nokia. So, the palm product is harder to find on their web
site...

http://www.intellisync.com/pages/Products/Intellisync-Handheld-Edition/For-Individuals/


So, we have
Satellite Forms. $$, most features, and even code/events for forms
on the palm. However, since they were
purchased by nokia..they are NOT likely
to give much effort to their competitor
and spend $$$ building the palm side
software.

Pendragon Forms $ less features, but good integration with
ms-access. (in fact, when you
launch
pendragion, it actually launches
ms-access!!
(so, they work well together)
- only complaint is no hi-res
support

HandiBase very affordable, forms are more limited
- no hi res support last time I
looked...

There is also DatVis...

http://www.dataviz.com/products/smartlisttogo/

I use documents to go on my palm T3, and dataviz have VERY nice software. I
have NOT used the smartlist "database" product, but it does support hi-res
on my
palm..which pendragon/satellite/handibase don't support.


Virtually all of the above products do have a download and trial.....

In addition to the software platform, you have to decide on the kind of
environment. A few real-estate sales people can use a normal unit. In a
industrial environment, you can't have people dropping $300 units and
breaking them all day long. Hence, you might need ruggized units, of which
several vendors make (they can surive a drop to a cement floor for
example.).
 
Thank you Albert for taking so much time to respond with a great reply.
The platform will be windows as all our machines are windows, I currently
have an pocket pc that I am using for a trail but I could use a palm if the
software is better. I looked into the tablet pc's and I think they might be
to fragile and maybe too expensive to use for my needs.

I know some portable bar code scanners can also do data input, I will be
looking today to see what platform they use. You have given me a great
start, I will post back if I have any info to add for others searching this
topic.
Thank you again
Michael
 
Back
Top