Hi John:
No, this isn't a problem per se. However, you don't want to use Access
here, MSDE is free and it's a lot easier to use and supports both RDA and
Merge Replication.. We have a whole SQL Server CE section here
http://www.devbuzz.com/content/init_...arting_out.asp and Rob Tiffany
(who wrote the only book on Pocket Access and eVB as well as a new Book on
Sql Server CE w/ the compact framework
http://www.devbuzz.com/content/init_...arting_out.asp) is one of our
forum Moderators. Anyway, if you REALLY want to use access, Peter Foot
wrote a wrapper for it (ADOCE) available at
www.inthehand.com which is a
wonderful product. It's very well priced and I know many many people who've
used it and the feedback is always the same - Excellent.
If you have GPRS access though, you can hit the SQL Server directly as long
as you want to expose it to the net (which you may not want to do). For
this, Web Services could easily fill in the gap and they are guite easy to
implement. Casey and
www.brains-n-brawn.com has done a ton of work with
data transfers over web services and he's got some great articles which are
quite complex but his discussion makes them clear as day.)
Anyway, you can use BlueTooth, 802.11 xxx , the cradle to access a network.
Once you have access you can use ActiveSync, Simple file moving, Web
Services, the SQL Client library, Merge Replication, RDA etc to get the data
around.
Head over to
www.devbuzz.com like I mention above for we have some great
resources. We've got pretty strong MVP support and the authors of just
about every CF related book is either a moderator or a regular visitor.
Also,
www.opennetcf.org is the BEST CF content site on the web, there's tons
of examples, an extensive (open source) libraray and a whole host of
Embedded and Compact Framework MVP's to assist you with anything you may
need.
--
W.G. Ryan, eMVP
http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
"John" <(E-Mail Removed)> wrote in message
news:ewrV$(E-Mail Removed)...
> Hi
>
> We have a .net database app with MS Access backend running in house over a
> windows 2000 server network. Is it possible to re-write the same app for
xda
> ii (http://www.xda-2.co.uk/under_the_bonnet.html) /windows mobile 2003
that
> can updated data from/to server? What means can be used to update the data
> (gprs?)? Is it too difficult to do this for someone with strong database
> skills i.e. does gprs etc. require a lot of knowledge of the underlying
> technology with a need to write code around it?
>
> If access is a problem then we can move to SQL Server, but is this at all
> possible?
>
> Thanks
>
> Regards
>
>
