Updating an Access database with a PDA

Archived from groups: comp.sys.handhelds (More info?)

"Keith Pierce" <kpierce@ermco-eci.com> wrote in message
news:13b5fb90.0408120723.31dd34f0@posting.google.com...
> I would like to use a wireless PDA to put information into an Access
> database that would reside on the network server. Basically, I work
> 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?
>
> 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, doubling the workload.

The PDA supports a form of access database called 'pocket access'. When the
conversion betwixt one and t'other is carried out, only the data table is
converted. So in order to do what you want to do, you would need to convert
the captured data into a regular access database and then cut and paste the
date from the converted database into the full dtabase.

The downside here is that although Microsoft provided the conversion for the
pocket access file, they neglected to provide the application itself.
However, Google for Pocket Database 4.1 which uses this file format. I
allows a free trial as well so you can evaluate it before you part with any
cash.

Ian.