Error 21060 w/Rep. Between Access and SQL Server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Glenn Cadoret (gcadoret_at_lycos.com)
Date: 07/15/04 

Date: Thu, 15 Jul 2004 07:11:52 -0700

Thank you all for your help.

Hilary's answer wasn't exactly on the money, but it led
me to the solution.

Seems the problem has its roots in the definition of the
publication. At one point in the definition process you
can choose options for "Immediate Updating" or "Queued
Updating". I had been choosing "Queued Updating". When
I chose neither of the options, that solved the problem.

Hilary's answer helped because if either of these options
are chosen the "Commands" tab she spoke of does not
appear. (I found that bit of information in the online
Replication Wizard help.) When I realized that, I tried
it without either option and it worked!

For the record, the status of the "Send Parameters in
Binary Format" seems to have no effect. I was able to
establish replication both with and without the option
turned on.

Again, many thanks for the help.

>-----Original Message-----
>I am trying to establish transactional replication
>between a SQL Server DB and an Access database. I keep
>getting the following error:
>
>SQL Server Enterprise Manager encountered errors
creating
>push subscriptions for the following Subscribers:
>
>ACCESS1: Error 21060: Could not subscribe because non-
>SQL Server Subscriber 'ACCESS1' does not support
>parameterized statements.
>
>What am I doing wrong? Any ideas?
>.
>

Relevant Pages