I blogged last week about why I’m glad Microsoft didn’t provide Pocket PC versions of their Access database and PowerPoint presentation applications(The “Missing” Pocket PC apps: Access & PowerPoint). So, what do you do if you need a database for the Pocket PC?
I noticed that Wei-Meng Lee has two articles on O’Reilly’s OnDotNet site about Microsoft’s high-end Microsoft SQL Server 2000 Windows® CE Edition (Developing Pocket PC Apps with SQL Server CE and Using Remote Data Access with SQL Server CE 2.0). But, SQL Server can be a bit daunting to non-programmers. Fortunately, there are a range 3rd party Pocket PC database applications that can fit the needs of everyone from non-programmers to expert programmers. Here’s the list of Pocket PC database applications that I know about:
I’ve used HanDBase quite a bit since it is simple to use it to create a database applet right on the Pocket PC with no programming required (even when using features like populated drop-down menus). However, it is not a fully relational database (as far as the version 2.75 I use goes. I have not tried version 3 yet). So, while it fits my needs for building small fast personal databases, it may not fit everyone’s requirements.
Unforunately, I do not know of any free or Open Source Pocket PC database applications.
Note: Although all of these third party applications can deal with a database created using Microsoft Access on the desktop, none of them (to my knowledge) can bring over the existing relational links or macros/VBA-scripts. And, the ActiveSync MDB to CDB translation has a 65,000 record limit.
Am I missing any Pocket PC databases (commercial or Open Source)? Got a favorite Pocket PC database app? Let me know!