Access 2000 Repliating to SQL Server 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been searching the Internet for a "How To" on how to replicate an Access 2000 database to a SQL Server 2000 database. I have a client that is running an application that I developed for them on an SQL Server 2000 database with asp.net as the front end. They have a need for certain users to work on a notebook out in the field where they will not have any connectivity. My initial idea was to write their system in Microsoft Access 2000 and the sychronize their database back to the SQL Server database at the end of the day when they can do a dialup.

I have not been able to find any useful information on how to get Access and SQL Server to work in this way. Is it possible and if so how do I do it.

Thanks for any help.
 
Unfortunately, this is not easily possible. It is not too difficult to
upsize from Access to SQL Server, but it is almost impossible to downsize
from SQL Server to Access. SQL Server is capable of replicating to Access,
but I think to implement this you would have to recreate all of your SQL
view/sp/udf objects in Access which could take a significant amount of time,
or prove impossible if you use certain TSQL functions...

Have you thought about installing MSDE on their laptops? This will enable
them to run replicated copies of the SQL Server database & should give you
the quickest working solution...



--
James Goodman
MCSE MCDBA
http://www.angelfire.com/sports/f1pictures/
Kreg said:
I have been searching the Internet for a "How To" on how to replicate an
Click to expand...
Access 2000 database to a SQL Server 2000 database. I have a client that is
running an application that I developed for them on an SQL Server 2000
database with asp.net as the front end. They have a need for certain users
to work on a notebook out in the field where they will not have any
connectivity. My initial idea was to write their system in Microsoft Access
2000 and the sychronize their database back to the SQL Server database at
the end of the day when they can do a dialup.
I have not been able to find any useful information on how to get Access
Click to expand...
and SQL Server to work in this way. Is it possible and if so how do I do
it.
 
Back
Top