Tip of the Month (July 2005)

OLE Objects in Pocket Access Databases (*.CDB Files)
----------------------------------------------------

When you transfer an Access Database (an .MDB file) to the handheld, Microsoft ActiveSync converts the Access Database to a Pocket Access Database (a .CDB file). Howerver, by default, the OLE objects are not included. Here's how to get them included....

When you transfer the Access Database (either by dragging and dropping it in a folder on the handheld or selecting or by selecting TOOLS | IMPORT DATABASE TABLES from ActiveSync), you are asked to select which tables and fields to include in the *.CDB file. Expand the table that contains the OLE object (by clicking on the + to the ledt of the table name) and then turn on the checkbox next to the OLE object column.