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

About login into sql server via asp.net

I want to design a form with C# that will able me to log in to my sql server with my sql login name and password.This should be the entry point, which is like the "SqlWebAdmin", Where i login first then have a view of databases that i have permission. The problem first is how to login into the sql server via ASP .net without knowing prior which database is mine?Any help plz?Most apps put their connect information in web.config, and read it out at run time.