Offline use

Hi
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:

> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:

>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
sql