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

Access

Is Access the best tool to use with SQL 2000 Server for a medium sized
company. This is the direction they plan to go with & it doesn't seem right
to me.
mare
Define "best." Yes, it is a tool, but there are many. It is easy to
develop and query attached SQL Server files.
Sincerely,
Anthony Thomas

"mare" <mare@.discussions.microsoft.com> wrote in message
news:62DC38BD-53BE-4B31-BF5D-92B8B29AFF66@.microsoft.com...
Is Access the best tool to use with SQL 2000 Server for a medium sized
company. This is the direction they plan to go with & it doesn't seem right
to me.
mare
|||mare,
To do what? Reporting, querying, full blown app? I personally would say
no. Depends on the skills you have in-house, budget, requirements, etc.
Many variables...
Define medium-sized company for us too. The UK govenment consider a
small or medium sized enterprise (SME) to be fewer than 250 employees,
and annual turnover not exceeding €40million. Your idea might be different.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
mare wrote:
> Is Access the best tool to use with SQL 2000 Server for a medium sized
> company. This is the direction they plan to go with & it doesn't seem right
> to me.
>
> mare

Access

Is Access the best tool to use with SQL 2000 Server for a medium sized
company. This is the direction they plan to go with & it doesn't seem right
to me.
mareDefine "best." Yes, it is a tool, but there are many. It is easy to
develop and query attached SQL Server files.
Sincerely,
Anthony Thomas
"mare" <mare@.discussions.microsoft.com> wrote in message
news:62DC38BD-53BE-4B31-BF5D-92B8B29AFF66@.microsoft.com...
Is Access the best tool to use with SQL 2000 Server for a medium sized
company. This is the direction they plan to go with & it doesn't seem right
to me.
mare|||mare,
To do what? Reporting, querying, full blown app? I personally would say
no. Depends on the skills you have in-house, budget, requirements, etc.
Many variables...
Define medium-sized company for us too. The UK govenment consider a
small or medium sized enterprise (SME) to be fewer than 250 employees,
and annual turnover not exceeding â?¬40million. Your idea might be different.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
mare wrote:
> Is Access the best tool to use with SQL 2000 Server for a medium sized
> company. This is the direction they plan to go with & it doesn't seem right
> to me.
>
> mare