In this vein, I have just finished building a fairly complex application for the Symbol SPT1700 (basically a ruggedized palm pilot with a built in laser scanner) for use in taking inventory physical counts.
The application data is tightly integrated with a microsoft access 2000 database (obtains its tables directly from access 2000 and uploads data directly to access 2000, no "go-between" intermediat files to deal with at all).
the development platform i am using is Satellite Forms by Pumatech. The visual basic like scripting made it simple. you can use global variables etc etc as well.
I control all the uploading and downloading of files to and from the palm device from a microsoft access 2000 form, it was a piece of cake.
I am currently in the process of creating another application for use in order taking (salesman uses the device to put together a customers order while browsing the sales yard with the client by scanning the barcodes on the items and entering the quantities the customer wants).
I am using the standard edition of satellite forms version 3.5.
Paul