Access 2000 to SQL Server 2000 Standard

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.
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.
>
|||Chris,
to follow from Hilary's post, if you are not familiar with merge
replication, the best resource is BOL. If you want a web setup guide, have a
look at this site:
http://www.mssqlcity.com/Articles/Re...MR/SetupMR.htm
HTH,
Paul Ibison
|||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[vbcol=seagreen]
> 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...
> the
this[vbcol=seagreen]
it[vbcol=seagreen]
useful[vbcol=seagreen]
available[vbcol=seagreen]
little[vbcol=seagreen]
books.
>
|||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[vbcol=seagreen]
> 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...
you[vbcol=seagreen]
> to
via[vbcol=seagreen]
> this
so
> it
> useful
> available
> little
> books.
>
|||Excellent article but any pointers how to trigger Access sitting on an
external network to push information into sql server (I forgot to mention
there is a firewall but we may be able to specify an IP and port which my IT
manager should allow). The article gets me 3/4 of the way there but how do I
point SQL Server at an Access Database sitting on an external LAN via the
internet.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:eSD5leTgEHA.644@.tk2msftngp13.phx.gbl...
> Chris,
> to follow from Hilary's post, if you are not familiar with merge
> replication, the best resource is BOL. If you want a web setup guide, have
a
> look at this site:
> http://www.mssqlcity.com/Articles/Re...MR/SetupMR.htm
> HTH,
> Paul Ibison
>
|||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.[vbcol=seagreen]
> 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...
> from
in[vbcol=seagreen]
beginner[vbcol=seagreen]
and[vbcol=seagreen]
the[vbcol=seagreen]
> Replication
linking[vbcol=seagreen]
> upgrade
> of
> you
> via
like
> so
>
|||Chris,
Not read the thread in detail, but if replicating Access XP/2000 to Access
XP/2000 is what you need then this does work over the internet using only a
standard IIS port. There's a Microsoft document 'Internet Synchronization
with the Microsoft Jet Database Engine: A Technical Overview', which is a
great help. I've had this working for about 2 years, and it does the job but
if you can you'll find SQL Server / MSDE replication more reliable and
easier to manage. You don't really need replication manager. I have some
code for our own 'replication scheduler' I'd be willing to share. Another
good site for information is www.trigeminal.com, where you can find another
'replication manager' program.
Tony.
"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.
>
|||My understanding is that this allows you to replicate an Access Database to
another Access Database over the internet. but does not allow you to
replicate an Access Database to a SQL Server or vice versa over the
internet.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Tony Toker" <xxxx@.xxxx.com> wrote in message
news:cfj3gr$k2s$1$830fa17d@.news.demon.co.uk...
> Chris,
> Not read the thread in detail, but if replicating Access XP/2000 to Access
> XP/2000 is what you need then this does work over the internet using only
a
> standard IIS port. There's a Microsoft document 'Internet Synchronization
> with the Microsoft Jet Database Engine: A Technical Overview', which is a
> great help. I've had this working for about 2 years, and it does the job
but
> if you can you'll find SQL Server / MSDE replication more reliable and
> easier to manage. You don't really need replication manager. I have some
> code for our own 'replication scheduler' I'd be willing to share. Another
> good site for information is www.trigeminal.com, where you can find
another[vbcol=seagreen]
> 'replication manager' program.
> Tony.
>
> "Chris Kennedy" <chrisknospam@.cybase.co.uk> wrote in message
> news:eEjmSFSgEHA.1972@.TK2MSFTNGP09.phx.gbl...
> the
this[vbcol=seagreen]
it[vbcol=seagreen]
useful[vbcol=seagreen]
available[vbcol=seagreen]
little[vbcol=seagreen]
books.
>
|||This is my understanding too. But if your application suits you may be able
to use DTS or some custom code to import/export data between the replicated
Access and SQL server DB's. Worked for us, but SQL server / MSDE replication
is a much better solution.
Much more info on microsoft.public.access.replication.
Tony
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:uGkQluhgEHA.2984@.tk2msftngp13.phx.gbl...
> My understanding is that this allows you to replicate an Access Database
to[vbcol=seagreen]
> another Access Database over the internet. but does not allow you to
> replicate an Access Database to a SQL Server or vice versa over the
> internet.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Tony Toker" <xxxx@.xxxx.com> wrote in message
> news:cfj3gr$k2s$1$830fa17d@.news.demon.co.uk...
Access[vbcol=seagreen]
only[vbcol=seagreen]
> a
Synchronization[vbcol=seagreen]
a[vbcol=seagreen]
> but
Another[vbcol=seagreen]
> another
via[vbcol=seagreen]
> this
so
> it
> useful
> available
> little
> books.
>