Discussion Locked

Looking for a mobile solution

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am looking for a mobile solution to meet the following needs:

1) Support a database with 1500 ? 2000 records. (Access /Visual Basic Database).
2) Quickly view these records while in emergency or crisis situations.
3) Enter Data and make changes to fields while working out in the community.
4) Ease of use for viewing and data entry.
5) Network connection.
6) Not immediately, but at least upgradeable for Internet and email connection. (dialup or wireless).

The solution I am looking for will be used by a nonprofit agency. Meanwhile I know my options range from Palm OS devices, Windows CE devices, and laptops.

7 replies

by frobo

Hi,

how about the Ipaq 3650 with 64 MB RAM and
WIN CE 3.0 (Later PocketPC 2000). You have PocketAccess for your Database, and Outlook + IE ... Youe neeed the Expansion Pack with Wireless Land and GSM Mobile Phone, so you have every where access to Internet and other resources. This is only an Idea, it depends strongly on :
Which Kind of Data you have.
How often the User has to enter and view Data.
How frequent the Data must be updatet via LAN and/or Phone.
First i would design the solution, and then look for the parts of the Puzzle.

regards

Frobo

by jbutcher

I think a viable solution is as follows:

Purchase Sony Vaio PictureBook. This is smaller than a laptop but has all of the features of a full blown system, i.e. Processor/Hard Disk etc. so you can load a full version of Office / Access

Purchase a USB NIC Card for Network Connection at Home Office

Purchase a PCMCIA Radio Modem from Sprint for Dial-Up/Internet Access

When you are at the office connected to the Network, copy the Access Database you want to work with in the field down to the laptops local hard drive but give it a different name.

While you are in the field make whatever changes/add/deletes you need to your local MS Access Database.

When you return to the office and hook back into the Network, create a link between the 2 databases and write a query to append non duplicate data to the master database. When you get ready to go back out to the field, recopy the master database back down.

The fastest direct method approach would be to use the laptop to establish a PC Anywhere Connection to the Home Office and Open the Database so all the info is live. This would also allow you to E-Mail and Internet Access on the Host Computer at the Home Office.

This discussion is closed to new replies.