MS Access Pull Subscription Replication with SQL Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kongo - 08 Feb 2006 08:59 GMT

We have a program that uses a central SQL Server 2000 for data storage.
To use the data externally, an access db is created that holds the
data.

Now changes can be made to the sql server and also to the 'detached'
access db that I want to synchronize. I read up/experimented with SQL
Server replication and found out that SQL Server is capable of doing
push replication to access db's.

However, since the access db will be online very infrequently, I want
to do a pull subscription from the access db using merge techniques.
That means that I want to sync the access db when I leave. I then do my
changes to the access db. When I come back I want to connect to the SQL
Server and merge the changes.

I have googled for hours and also read the Access 2002 Enterprise
Developer Handbooks but found nothing. Is this even possible in access?
I can only find how to create replicas to access masters.

If this isn't possible I have the other option of using a MSDE on the
externals. Does it support replication?

Thanks in advance!
kongo

Reply to this Message

David W. Fenton - 08 Feb 2006 16:57 GMT

> We have a program that uses a central SQL Server 2000 for data
> storage. To use the data externally, an access db is created that
[quoted text clipped - 17 lines]
> If this isn't possible I have the other option of using a MSDE on
> the externals. Does it support replication?

I can't really answer your question. You'd need to find out in
heterogeneous SQL Server replication if the Jet partners can
participate in full merge replication.

As to MSDE, I know it has certain limitations in comparison to full
SQL Server, and I'm pretty sure that one of them involved
replication, but I don't know if it causes a problem for you.

I don't have any clients using SQL Server so this issue has never
arisen (and it could only arise in the situations where a user
needed to work occasionally disconnected). And the subject just
doesn't come up in this newsgroup.

I would suggest looking for a SQL Server replication newsgroup or
forum and posting your question there. I would think it would be a
FAQ in that context. In this context, it's really off-topic, since
it does not involve Jet replication at all (and, yes, this newsgroup
is not properly named, in my opinion, since "Access replication" is
a JET technology, and does not require Access to be used, nor does
it work very well with anything other than Jet data).

Signature

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

Reply to this Message

kongo - 08 Feb 2006 20:41 GMT

I'm not quite sure if I was misunderstood here.

I am pretty sure that SQL Server supports merge replication with Access
databases, otherwise the following screenshot from Enterprise Manager
(after selecting Merge Repl. wouldn't make a lot of sense)

http://img146.imageshack.us/my.php?image=sqlrep1fg.png

My real question (that's why I posted to *.access) is:

Can (and if yes, how) I tell MS Access to be a subscriber (slave?) to
an SQL Server replication so that I can update/merge/? the databases.

Reply to this Message

David W. Fenton - 09 Feb 2006 02:33 GMT

> I'm not quite sure if I was misunderstood here.
>
[quoted text clipped - 10 lines]
> to an SQL Server replication so that I can update/merge/? the
> databases.

This not an Access/Jet question. It is something that is
accomplished through SQL Server. Even if (as seems highly unlikely)
this is something that is accomplished via Access, it still has
zilch to do with the topic of this newsgroup, which is JET
replication (as available in Access).

I've been reading this newsgroup for about 7 years or so, and SQL
Server replication has never been a topic of discussion here, for
the very reason that it is orthogonal to the topic of this
newsgroup.

In short, I simply don't know the answer to your question. I do know
this is not a very profitable forum to be seeking that answer.

Signature

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

Reply to this Message