Microsoft KB Archive/254946

{|
 * width="100%"|

HOWTO: Move an Access Database File from a Desktop PC to a Palm-size PC

 * }

Q254946

-

The information in this article applies to:


 * Microsoft ActiveSync versions 3.0, 3.1
 * ActiveX Data Objects 1.0 SDK for Windows CE, version 2.0
 * Microsoft Windows CE Toolkit for Visual Basic 6.0, version 1.0
 * Microsoft eMbedded Visual Basic, version 3.0

-

SUMMARY
This article demonstrates how to move a Microsoft Access database file (.mdb) from the Desktop computer to the Palm-size PC when the computers are connected through Microsoft ActiveSync.

MORE INFORMATION
On the Palm-size PCs that run Microsoft Windows CE 2.11, the database files are stored in .cdb file format, which is what Microsoft Pocket Access uses. When you move the Microsoft Access database file from the Desktop computer to the Palm-size PC, Microsoft ActiveSync converts the file from .mdb format to .cdb format. Because Pocket Access is not shipped on the Palm-size PCs, you can run into problems during the conversion if the required (ADOCE) files do not exist on the Palm-size PC. The ADOCE files for Palm-size PC are shipped with Palm-size PC 1.2 SDK and can be downloaded from the following Microsoft Web site:

"Palm-size PC 1.2 SDK" After you download the Palm-size PC 1.2 SDK and install it on the Desktop computer, you should find the required ADOCE files for each supported processor under the ..\wce211\ms palm size pc\adoce folder. One way to download these files to the Palm-size PC is through Windows CE Toolkit for Visual Basic (VBCE), as follows:

Start a Windows CE PsPC project in VBCE.

On the Project menu, select References. Click to select Microsoft CE ADO Control (ADOCE) 2.0, and then click OK. This reference should point to the Msceadodt.dll file under the ADOCE folder mentioned above.

On the Project menu, select Project1 Properties. Make sure that the target to run on is the Palm-size PC 2.11 (Default Device).

Press the F5 key to run the project on the remote device. VBCE downloads the required run-time files to the device, including the following five ADOCE files that are required for the appropriate processor:


 * adosync.dll
 * adoceres.dll
 * adocereg.dll
 * adocedb.dll
 * adoce.dll

Once the required ADOCE files are downloaded successfully to the Palm-size PC device, you can drag the .mdb file from the Desktop computer and drop it to the device using ActiveSync. ActiveSync automatically converts the file from .mdb format to .cdb format.


 * 1) Start Microsoft ActiveSync.
 * 2) On the File menu, select Explore to open the Mobile Device window. Double-click on the folder to which you want to copy the file.
 * 3) On the Desktop computer, browse the .mdb file that you want to copy to the device in Windows Explorer. Drag the .mdb file and drop it in the desired folder on the Palm-size PC.
 * 4) The Import from Database to Mobile Device dialog box appears, and if the required ADOCE files do not exist on the Palm-size PC, the following error message appears:
 * 5) If all the required ADOCE files exist on the device, the .mdb file is successfully converted to .cdb file on the device.

Additional query words:

Keywords : kbWinCE kbGrpVB kbWinCE211 kbDSupport kbVBM300

Issue type : kbhowto

Technology : kbvcSearch