Synchronising access and sql server

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

Is it possible/feasible to have two-way replication (synchronisation)
between an access database and a sql server 2005 database? I am just
wondering if it is more robust than replication between two access
databases.

Thanks

Regards
 
Hi,
As i did this in merge replication between 2 sql server .Runs smooth.

see these articals for help
Theory for merge replication.
http://www.awprofessional.com/articles/article.asp?p=25070&rl=1
http://www.windowsitpro.com/SQLServer/Article/ArticleID/8825/8825.html
_____________________________________________
For replication between access and Sql Server
---------------------------------------------
Create a linked server and can work with two way Merge replication

But a bit slow.

From
Doller
 
Back
Top