sql server replication: 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.

Right click on your publication, select publication properties, click on the
articles tab. Click on the browse button (the three ellipses to the right of
the article), in the article properties tab, click on commands, all the
commands should read SQL. The send parameters in binary format and the
create the stored procedures.... options should be cleared.


--
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html


[quoted text, click to view]

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.

[quoted text, click to view]