Error 21060 w/Rep. Between Access and SQL Server

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?
Glenn,
please can you script out your publication and the articles (just schema)
and I'll take a look.
My guess is it is to do with filters, but we'll see.
Regards,
Paul Ibison
|||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
"Glenn Cadodret" <gcadoret@.lycos.com> wrote in message
news:2d0d501c469fd$7ea8ca90$a401280a@.phx.gbl...
> 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?