I would like to use a wireless PDA to put information into an Access
database. The database file would be stored on the network server but
Access would be running on a host computer attached to the network.
The PDA would have a wireless link to the host computer.

Here is the scenerio. I work in the Quality Assurance department for
a manufacturer. When an inspector spots a nonconformance(defect), I
would like them to be able to use a wireless PDA equiped with a bar
code scanner to create a new record for the Access database and update
the records of nonconformances that have been repaired. I only need
the form on the PDA. I have been advised that setting up a web page
with the form on the host computer and downloading it to the PDA to
fill in, then uploading the completed page to the host is the way to
go. Anyone done this? Does it sound feasable?

This would be the first use of this capability, but if it works, I
think we can find many more uses besides Quality Assurance for this in
our factories. I think it could save a mountain of paperwork too.
Right now the paper forms have to be filled out by the inspector, then
keyed into the system later. A printed form is then distributed to
the inspectors for updating and documenting repairs, and that
handwritten information then has to be keyed back into the system and
reports generated. We are using Excel for tracking and reports, I
want to get away from that too.

Keith,
ExpensePlus is an expense reporting software that runs on PalmOS PDA's and
syncronizes with Access & Excel to generate it's reports on the host PC.
However they do what they do to get their data from a PalmOS PDA to Excel
should be similar to what you are trying to do. Check out the software from
WalletWare at http://www.walletware.com.

"Keith Pierce" <kpierce (AT) ermco-eci (DOT) com> wrote