<freeman642@gmail.com> wrote in message
news:1180004621.496305.101600@p47g2000hsd.googlegroups.com...
>I have an access database that I want to transactionally replicate
> into SQL Server 2000. Can someone point me in the right direction for
> getting the source connection in enterprise manager? Or a brief
> example o how to start this? Have looked at SQL to SQL, but not Access
> to SQL.
>
> Thanks John
>

On 24 May, 13:16, "Hilary Cotter" <hilary.cot...@gmail.com> wrote:
> This can't be done easily. You can replicate from SQL Server 2000 to an
> Access database if you create an odbc datasource subscriber. Have a look at
> this to get an idea of how it is done.http://www.nwsu.com/lowres_replication_ch02.pdf
>
> You could create a merge publication on your SQL Server and create the
> Access database as a subscriber. This will replicate the changes in the
> access database back to SQL Server.
>
> <freeman...@gmail.com> wrote in message
>
> news:1180004621.496305.101600@p47g2000hsd.googlegroups.com...
>
>
>
> >I have an access database that I want to transactionally replicate
> > into SQL Server 2000. Can someone point me in the right direction for
> > getting the source connection in enterprise manager? Or a brief
> > example o how to start this? Have looked at SQL to SQL, but not Access
> > to SQL.
>
> > Thanks John- Hide quoted text -
>
> - Show quoted text -