Re: Replicate to MS Access via the Internet
From: Cheval (NoSpam.Ask_at_ForEmail.com)
Date: 10/25/04
- Next message: Josh Knutkowski: "Log Shipping Maintenance Plan Creation Problem"
- Previous message: Phil: "New articles will not replicate to subscribers"
- In reply to: Hilary Cotter: "Re: Replicate to MS Access via the Internet"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 25 Oct 2004 21:52:47 GMT
Ok, sorry. Yes, I stand corrected. :)
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:ew6xgjouEHA.2316@TK2MSFTNGP15.phx.gbl...
But the poster wants to replicatioin from SQL Server to MS Access databases
over the internet. To quote him/her:
"Can I use SQL Server's inbuilt replication to replicate between a SQL
Server
database and a number of MS Access 97, 2000 and 2002 databases over the
internet? "
This article refers to replicating from access databases to other access
database via the internet.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Cheval" <NoSpam.Ask@ForEmail.com> wrote in message
news:%1Ved.37775$5O5.11821@news-server.bigpond.net.au...
> If MS Access does not support Internet replication, then you should let MS
> know, as they seem to think is has since Office 97.
> http://support.microsoft.com/kb/q181371/
>
> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> news:uzXe5%23FuEHA.1472@TK2MSFTNGP10.phx.gbl...
> Replication does not support replicating to an Access database over the
> internet. It does support replicating to another SQL or MSDE database over
> the internet or to a local access database, or an access database on a
UNC.
>
> "dazzah" <dazzahall removethis at hotmail.com> wrote in message
> news:A9973C28-DAEA-494B-A843-86EEA329E06A@microsoft.com...
> > Can I use SQL Server's inbuilt replication to replicate between a SQL
> Server
> > database and a number of MS Access 97, 2000 and 2002 databases over the
> > internet? I need to replicate in both directions and Jet 4.0 is
installed
> on
> > the client computers. Are there any solutions that will do this for me,
> or
> > do I have to write a web service and the replication code myself? (The
> web
> > server supports ASP.NET and hence I can easily write a web service in
> VB.NET
> > or C#.)
> >
> > We have a SQL Server database on a web server and a number of clients
that
> > use Access to store their data locally. The clients modify their local
> > database and the system administrator occasionally updates the SQL
Server
> > database. The clients will on a weekly basis (or as required) replicate
> > their changes to the SQL Server database and also replicate the changes
in
> > the SQL Server database to their local databases. The clients all have
> > unique data sets.
> >
> > I have found contradictory information on the newsgroups about using SQL
> > Servers inbuilt replication technology. Some say that it will achieve
> what I
> > want, others say that it won't work. Also some suggest that replication
> is
> > quite complex and can be flaky.
> >
> > Looking forward to your suggestions,
> >
> > Darren
> >
>
>
>
- Next message: Josh Knutkowski: "Log Shipping Maintenance Plan Creation Problem"
- Previous message: Phil: "New articles will not replicate to subscribers"
- In reply to: Hilary Cotter: "Re: Replicate to MS Access via the Internet"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
