Problems with replicaion to JET 4.0 subscribers

Hi,
I have a couple of queries I wonder if anyone can help me with.
Merge replcation to Access with Merge ActiveX control.
Using MSDE subscriber, takes about 30 secs to download schema and
data.Using Access, takes about 5 minutes, and the file size is about 5
times what I would expect. Data is correct, though. Is this just
excessive freespace being allocated?
JET 4.0 Transactional replication subscriber.
I have set up a linked server to act as a subscriber. I can access the
subscriber database via the linked server, and apparently add it as a
subscriber via 'Configure Publishers / Subscribers' - but when trying
to set up a push subscription, it does not show as an enabled
subscriber.
I set up the linked server via sp_addlinkedserver, set rpc on in both
directions and collation compatible with sp_serveroption, and set the
login to the linked server to 'Admin'
I've obviously missed a trick, but I cant see what it is...
Many thanks for your help
Duncan Tilley
Is this publication enabled for jet subscribers? I suspect it is not.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Duncan Tilley" <me@.privacy.net> wrote in message
news:0kde129mhmhb6af21jgcnn2q94fioguvl2@.4ax.com...
> Hi,
> I have a couple of queries I wonder if anyone can help me with.
>
> Merge replcation to Access with Merge ActiveX control.
> Using MSDE subscriber, takes about 30 secs to download schema and
> data.Using Access, takes about 5 minutes, and the file size is about 5
> times what I would expect. Data is correct, though. Is this just
> excessive freespace being allocated?
> JET 4.0 Transactional replication subscriber.
> I have set up a linked server to act as a subscriber. I can access the
> subscriber database via the linked server, and apparently add it as a
> subscriber via 'Configure Publishers / Subscribers' - but when trying
> to set up a push subscription, it does not show as an enabled
> subscriber.
> I set up the linked server via sp_addlinkedserver, set rpc on in both
> directions and collation compatible with sp_serveroption, and set the
> login to the linked server to 'Admin'
> I've obviously missed a trick, but I cant see what it is...
>
> Many thanks for your help
> Duncan Tilley
>
|||On Thu, 16 Mar 2006 07:21:59 -0500, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:

>Is this publication enabled for jet subscribers? I suspect it is not.
Hi Hilary
Thanks for the reply.
Err, yes, you're right... Now I feel stupid...
Many Thanks
Duncan
sql