Syncing with remote db

[john]

Archived from groups: microsoft.public.pocketpc (More info?)

Hi

We have an access db running on a windows 2003 server. The server is
connected to the internet via ADSL. I would like a windows mobile 2003 based
vb.net app to sync data from the server, ideally via gprs, from time to
time, the pda and the server have the same info. What is a good way to go
about doing the data sync between the pda and the server? Do we have to
upsize the server access db to sql server before it can sync with pda sql
server ce, or can we keep the access app as it is?

Thanks

Regards

 

[Guest]

Archived from groups: microsoft.public.pocketpc (More info?)

Take a look at Syware's mEnable. It should do what you want.

One little personal opinion.... You say "we". So, I assume you are trying to
use Access in a multi-user situation. <FLAME PROTECTION ON>I think Access is
a very capable single user database but I recommend against using it in a
multi-user situation. </FLAME PROTECTION OFF>. You might want to consider
going to a more robust database server even if mEnable would solve your
current situation.
--
Todd Ogasawara, MS-MVP/Mobile Devices
Online Editor - http/MobileViews.com/ -- PDA & Wireless Info
http/www.OgasaWalrus.com/MobileDot/ - MobileViews Brief News & Comments

"John" <John@nospam.infovis.co.uk> wrote in message
news:uIK4Z0cpEHA.1296@TK2MSFTNGP12.phx.gbl...
> Hi
>
> We have an access db running on a windows 2003 server. The server is
> connected to the internet via ADSL. I would like a windows mobile 2003
> based
> vb.net app to sync data from the server, ideally via gprs, from time to
> time, the pda and the server have the same info. What is a good way to go
> about doing the data sync between the pda and the server? Do we have to
> upsize the server access db to sql server before it can sync with pda sql
> server ce, or can we keep the access app as it is?
>
> Thanks
>
> Regards
>
>

 

[Guest]

Archived from groups: microsoft.public.pocketpc (More info?)

.... and in this case SQLEnable from the same Syware (www.syware.com) would
enable you to connect to MS-SQL.

--
Helio Diamant - MS/MVP Mobile Devices
http/www.pocketpcfreak.com


"Todd Ogasawara, MVP Mobile Devices" <Todd_MSN@NOSPAMmsn.com> wrote in
message news:%238OJU2epEHA.3520@TK2MSFTNGP11.phx.gbl...
> Take a look at Syware's mEnable. It should do what you want.
>
> One little personal opinion.... You say "we". So, I assume you are trying
to
> use Access in a multi-user situation. <FLAME PROTECTION ON>I think Access
is
> a very capable single user database but I recommend against using it in a
> multi-user situation. </FLAME PROTECTION OFF>. You might want to consider
> going to a more robust database server even if mEnable would solve your
> current situation.
> --
> Todd Ogasawara, MS-MVP/Mobile Devices
> Online Editor - http/MobileViews.com/ -- PDA & Wireless Info
> http/www.OgasaWalrus.com/MobileDot/ - MobileViews Brief News & Comments
>
> "John" <John@nospam.infovis.co.uk> wrote in message
> news:uIK4Z0cpEHA.1296@TK2MSFTNGP12.phx.gbl...
> > Hi
> >
> > We have an access db running on a windows 2003 server. The server is
> > connected to the internet via ADSL. I would like a windows mobile 2003
> > based
> > vb.net app to sync data from the server, ideally via gprs, from time to
> > time, the pda and the server have the same info. What is a good way to
go
> > about doing the data sync between the pda and the server? Do we have to
> > upsize the server access db to sql server before it can sync with pda
sql
> > server ce, or can we keep the access app as it is?
> >
> > Thanks
> >
> > Regards
> >
> >
>
>