Data collection form sync to Access

[johnnygeo]

I have an Access DB which I would like to populate using data collected via palm handheld. Each day, the Access database will prepare a template to be filled in. This template will be published to the handheld where it will be filled in. On the next sync, if the template is filled in the data will be pulled into Access and the template removed and/or replaced with the next template.

I'm looking for a solution that doesn't require any additional software (I can use Access VB to create just about any kind of output and read the input). Quick and dirty is OK. For example, in another application I'm using Access to read/write Outlook notes which synchronize automatically. I'm looking for something a little more robust for this one.

Can anyone recommend an online reference that would help me in creating and managing synchronizable palm files?

 

[briand2]

I think you might as well get some software for the Palm (it's not expensive), such as SmartListToGo relational database (from Dataviz) or HanDBase or similar. I personally use SmartListToGo to do various tasks and I just set it to sync directly with tables in Access; it's pretty good.

Regards,

Brian