Re: Access 2000 to SQL Server 2000 Standard

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Hilary Cotter (hilaryk_at_att.net)
Date: 08/13/04 

Date: Fri, 13 Aug 2004 09:47:18 -0400

AFAIK you can't replicate to an access database over the internet. So my
book does not cover this:) I do discuss how to set up an access database as
a Subscriber though.

If you can convert your Access database to MSDE you could do this. You would
do this using the ActiveX controls. These controls have a
DistributorAddress/DistributorNetwork, PublisherAddress/PublisherNetwork
properties which will allow you to pull the Susbcription over the internet.
I also discuss this in the book. 

-- 
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Chris Kennedy" <chrisknospam@cybase.co.uk> wrote in message
news:eQ7CeuTgEHA.1196@TK2MSFTNGP11.phx.gbl...
> I need to have a button on an access form which pushes the access data
from
> an external network to our local sql server. It has to be done via the
> internet and there will be a firewall etc. The merge replication stuff in
> BOL doesn't address the internet delivery in enought detail for a beginner
> like me. I was looking at Office XP developer with replication manager and
> doing it Access XP to Access XP on one of our web server and then link the
> table to SQL server. Any thoughts? Does your book cover Access?
Replication
> covers many of the problems of clients want addressed in terms of linking
> their local information to online systems but many clients will not
upgrade
> to SQL Server so I am looking at either Access XP developer or some kind
of
> custom .net component which sends the infomation via an XML Dataset and
> merges it with a dataset on our web server. At least the .net solution
> bypasses any firewall problems but it is reinventing the wheel to a big
> extent.
>
> "Hilary Cotter" <hilaryk@att.net> wrote in message
> news:%23C4hkETgEHA.2916@TK2MSFTNGP12.phx.gbl...
> > Merge Replication with the Access Database as a Subscriber will allow
you
> to
> > replicate from Access to SQL Server and vice versa.
> >
> > -- 
> > Hilary Cotter
> > Looking for a book on SQL Server replication?
> > http://www.nwsu.com/0974973602.html
> >
> >
> > "Chris Kennedy" <chrisknospam@cybase.co.uk> wrote in message
> > news:eEjmSFSgEHA.1972@TK2MSFTNGP09.phx.gbl...
> > > Sorry for the crosspost!!
> > >
> > > I need a way of replicating from an Access Database to an SQL Server
via
> > the
> > > internet. It is Access 2000 to SQL Server 2000 Standard. I would like
> this
> > > functionality to be fairly flexible (which is probably asking a lot)
so
> it
> > > could work with Access 2000 upwards, as I can see this being really
> useful
> > > to several clients who have Access information. I have looked at the
> > > replication manager but that appears to be discontinued and only
> available
> > > in developer additions. You would think the information would be a
> little
> > > easier to find. Can anyone point me to some websites, resources or
> books.
> > > Regards, Chris.
> > >
> > >
> >
> >
>
>
Quantcast