sql server replication: MSAccess as a Publisher to SQLServer -- sql server replication

MSAccess as a Publisher to SQLServer

Ed
11/6/2003 10:37:54 AM

sql server replication:

Does anyone have samples of using MSAccess 2000 as the
publisher to a SqlServer 2000 subscriber? The
hetergeneouus samples from MS do not address MsAccess

Re: MSAccess as a Publisher to SQLServer

Hilary Cotter
11/6/2003 8:38:23 PM

can't be done. However MSDE can be a publisher or a subscriber in merge
replication. It can only be a subscriber in transactional
publication.

Merge replication is limited to a max database size of
2Gigs, and I believe is functionally limited to 5
concurrent connections. You can have more (IIRC) but
performance on the additional connections is not good.

Access can be a subscriber to replication. You might get the functionality
you need by making it a subscriber to a SQL Server merge publication.

[quoted text, click to view]