Access DB for SmartPhone ?

[Sabareesh_krishnamoorthy]

Hi,

would it be possible to use Access as a DB for SmartPhone. I need to push a
light DB on the smartphone.

if i simply copy the access mdb file to the device, can i access the data
using ADO?

please do let me know.
thanks and regards,
-Sabareesh K

 

[Peter Foot [MVP]]

Smartphone does not support Pocket Access or the ADOCE control so it is not
possible to easily convert an access database to the device to use. It is
still possible to use the underlying CEDB database engine by P/Invoking the
API calls but this is not straightforward - and it does not have regular
database features such as field names and querying which ADOCE and "Pocket
Access" adds on top of the basic CEDB engine.

Your best bet for a small data store is to use XML which you can easily load
into a DataSet, or for a more compact solution use comma separated values
(CSV) text files. OpenNETCF has a library which can assist in reading and
writing a DataTable to csv file:-
http://www.opennetcf.org/csv.asp

Peter

--
Peter Foot
Windows Embedded MVP

In The Hand
http://www.inthehand.com

 

[Sabareesh_krishnamoorthy]

Thanks peter. the article was useful indeed.

-Sabareesh K