Moving Databases Between the Desktop and Device

You can move database tables back and forth between a desktop computer and an H/PC. The databases stored on the desktop computer are in Microsoft® Access database format. The databases stored on the H/PC are stored in standard Windows CE-based tables with additional information added to the ADOCE system tables.

The following procedures show you how to create and convert a database using ADOCE.

    To create a Microsoft Access 97 table on the desktop computer

1. Open Microsoft Access and create a new, empty database.
2. Save the database as Adoce.mdb.
3. Make a new table and open it in Design view.
4. Add the fields to the table.

   The following table shows the field names and field types to use.

5. Close Design view.
6. Save the table as Table1. After you save the table, a dialog box appears. Choose No to the dialog box query regarding primary keys. ADOCE does not support primary keys.
7. Open the table in Datasheet view.
8. Add sample data to the table.
9. Close Access and save your data.

    To copy the database from the desktop computer to the device

1. Connect the H/PC to the desktop computer.
2. Open the Mobile Devices window of Windows CE Services, and then choose Import Database Tables from the Tools menu.
3. Enter C:\Adoce.mdb in the Open dialog box, and then choose OK.
4. Choose OK to copy the entire table to the Databases folder on the H/PC. You can also expand the tables and choose individual fields.

    To copy the database from the device to the desktop computer

1. Choose Export Database Tables from the Tools menu in the Mobile Devices window.
2. Type C:\ADOCE.mdb in the Location dialog box.
3. Select Table1, and then clear every other table in the Select the tables to copy box.
4. Select the box labeled Overwrite existing tables and/or data, and then choose OK. The converted table from the device replaces the table in the file.
5. Open the file Adoce.mdb in Access to see what changes have occurred.

   The AutoNumber field has been changed to Number because ADOCE does not support the AutoNumber field type.

This is great, but how do I do this programmatically?