Access Database transactional replicated into SQL Server 2000

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
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.
<freeman642@.gmail.com> wrote in message
news:1180004621.496305.101600@.p47g2000hsd.googlegr oups.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
>
|||thanks Hilary thats a great idea. Never thought of that. 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.googlegr oups.com...
>
>
> - Show quoted text -
sql