Data On The Run 3.0 Released

[Jason Dunn]

<a href="http://www.biohazardsoftware.com/dataon.htm">http://www.biohazardsoftware.com/dataon.htm</a><br /><br />Data On The Run has hit the 3.0 level and has a few improvements added, mostly in the area of speed. If you're looking for a mobile database application, it's worth checking out.<br /><br /><img src="http://www.pocketpcthoughts.com/images/dunn2002/formview.gif" /><br /><br />• Includes greatly improved performance<br />• No 30 field limit on form view<br />• Faster sorting<br />• Easier table switching<br />• An "all fields" search<br />• Saved queries, and more!<br /><br />Data On The Run 3.0 can be <a href="http://www.handango.com/PlatformProductDetail.jsp?siteId=311&platformId=2&productType=2&catalog=0&amp;sectionId=0&productId=15885">purchased for $12.95</a> (affiliate link), but if you use the code "35C142" you'll save $2 off that price.

[msprague]

As far as I can tell this is limited to a form for modifying a single table. Is there a similar product that can be used to build a form and enter data into a multi-table relational database? Does anyone know of a comparison that has been done on the plethora of DB apps out there?
Thanks.

[Sven Johannsen]

You can actually manipulate multiple tables in DOTR, although relationships are not supported. That is not a DOTR limitation, but rather an ActiveSync Access conduit limitation.

ActiveSync provides a conduit for syncing Access database information from the desktop .mdb to the CE format .cdb. It only syncs tables. Which tables and fields within those tables, is fully configurable. It is a true sync. That is if you make a change in one record on the PPC and a change in a different record on the desktop, the changes will be merged on both copies, just like the PIM information. It is not just a copy of the latest full document as file syncing is.

There are numerous DB options for the PPC, many with relational capabilities, but none that can use the AS Access conduit as the file transfer system as it itself doesn't support relationships. DOTR is probably the simplest way of getting and manipulating data from an Access DB onto your PPC, given that you don't depend on relational tables.

To get an idea of what is available for PPC take a look at http://www.microsoft.com/mobile/pocketpc/tips/database.asp