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

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" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> 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
>
>
>

Thanks peter. the article was useful indeed.

-Sabareesh K
"Peter Foot [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in
> message news:(E-Mail Removed)...
> > 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
> >
> >
> >
>
>