E
Eric
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?
usable program that's simple. Anyone have a suggestion?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kyle
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.
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.
E
Eric
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.
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.
K
Kyle
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...!)
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...!)
E
Eric
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
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