Synchronising/replicating access with sql server

[John]

Hi

Is there a way to synchronise/replicate an access db with sql server 2000
db, short of writing the code oneself?

Thanks

Regards

[Tom van Stiphout]

On Sun, 25 Dec 2005 01:24:15 -0000, "John" <Jo**@nospam.infovis.co.uk>
wrote:

There is no specific replication between these two disparate systems.
You may want to look into setting up your Access db as a Linked Server
in SQL Server: perhaps it's possible to set up replication with a
linked server.

-Tom.

Hi

Is there a way to synchronise/replicate an access db with sql server 2000
db, short of writing the code oneself?

Thanks

Regards

[David W. Fenton]

Tom van Stiphout <no*************@cox.net> wrote in
news:f2********************************@4ax.com:

On Sun, 25 Dec 2005 01:24:15 -0000, "John"
<Jo**@nospam.infovis.co.uk> wrote:

Is there a way to synchronise/replicate an access db with sql
server 2000 db, short of writing the code oneself?

There is no specific replication between these two disparate
systems. You may want to look into setting up your Access db as a
Linked Server in SQL Server: perhaps it's possible to set up
replication with a linked server.

Huh? Jet 4 and SQL Server 2K support heterogeneous replication. It's
not as full-featured as Jet-to-Jet or SQL-to-SQL replication, but it
does exist.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Tom van Stiphout]

On Sun, 25 Dec 2005 13:56:04 -0600, "David W. Fenton"
<XX*******@dfenton.com.invalid> wrote:

I read the below in the help file:
You can programmatically control the exchange and synchronization of
information among members in a replica set in Microsoft Access 2000
and later versions by using Jet and Replication Objects (JRO). JRO can
only be used with Microsoft Access databases.

What other way is there?

-Tom.

Tom van Stiphout <no*************@cox.net> wrote in
news:f2********************************@4ax.com :

On Sun, 25 Dec 2005 01:24:15 -0000, "John"
<Jo**@nospam.infovis.co.uk> wrote:

Is there a way to synchronise/replicate an access db with sql
server 2000 db, short of writing the code oneself?

There is no specific replication between these two disparate
systems. You may want to look into setting up your Access db as a
Linked Server in SQL Server: perhaps it's possible to set up
replication with a linked server.

Huh? Jet 4 and SQL Server 2K support heterogeneous replication. It's
not as full-featured as Jet-to-Jet or SQL-to-SQL replication, but it
does exist.

[David W. Fenton]

Tom van Stiphout <no*************@cox.net> wrote in
news:u8********************************@4ax.com:

On Sun, 25 Dec 2005 13:56:04 -0600, "David W. Fenton"
<XX*******@dfenton.com.invalid> wrote:

I read the below in the help file:
You can programmatically control the exchange and synchronization
of information among members in a replica set in Microsoft Access
2000 and later versions by using Jet and Replication Objects
(JRO). JRO can only be used with Microsoft Access databases.

What other way is there?

When a Jet db is participating in heterogeneous replication with a
SQL Server, my understanding is that it is not using Jet replication
at all. I do not know how it works, but I don't believe it has
anything at all to do with Jet replication -- the Access database
becomes a member of the SQL Server's set of replicated databases.

I know that it's definitely possible to do heterogeneous
replication. I do not know the details of how it's done.

I do know that it supports a limited number of options compared to
what would be available with all-Jet or all-SQL replication.
However, I cannot comment on the exact limitations. I do not know if
an Access db can be a full merge replication partner with a SQL
Server or if it can only be a subscriber (SQL Server replication is
conceptually rather different from Jet replication).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/