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: Chris Kennedy (chrisknospam_at_cybase.co.uk)
Date: 08/13/04 

Date: Fri, 13 Aug 2004 15:01:56 +0100

Presumably they could keep their Access database, install MDSE and just set
up Access as a linked database. That would cause minimal disruption and no
cost. How much is your book?

"Hilary Cotter" <hilaryk@att.net> wrote in message
news:%23cHBixTgEHA.3348@TK2MSFTNGP12.phx.gbl...
> 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