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
- Open Microsoft Access and create a new, empty database.
- Save the database as Adoce.mdb.
- Make a new table and open it in Design view.
- Add the fields to the table.
The following table shows the field names and field types to use.
Field name
|
Data type
|
One |
AutoNumber |
Two |
Text |
Three |
Number |
Four |
Memo |
- Close Design view.
- 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.
- Open the table in Datasheet view.
- Add sample data to the table.
- Close Access and save your data.
To copy the database from the desktop computer to the device
- Connect the H/PC to the desktop computer.
- Open the Mobile Devices window of Windows CE Services, and then choose Import Database Tables from the Tools menu.
- Enter C:\Adoce.mdb in the Open dialog box, and then choose OK.
- 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
- Choose Export Database Tables from the Tools menu in the Mobile Devices window.
- Type C:\ADOCE.mdb in the Location dialog box.
- Select Table1, and then clear every other table in the Select the tables to copy box.
- 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.
- 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.