Data Replication From SqlServer DB to MS Access DB

Question

Hello Guys

I am going to Developing one Web Application and One Windows Application:

Development Tools: C#.net 3.5 framework, Sql Server 2012, Access 2007

In Web Apps use Sql Server Database and this Web Application Use for Administrator and Admin can operate all the data operation (like Insert,Update,Delete any thing)

Windows Apps installing on Client(User) System with MS Access Database.

My Question is that : When Admin Inserting a New Data or Updating existing data at Sql Server then this effect doing on Client(user) System Access database. How do this ?

Thanks.....

Sumit Jolly · Answer

in msaccess you can use Link feature to link sqlserver database and get it updated? Now are you OK if user does this stuff by opening mdb file and clicking Link evertime there is new data in sqlserver or you want to automate this too?

Pnkl · Answer

Bcoz if every client have no internet connection or connection is poor. So setup gives with some required db and admin updated db then server db effect on client db

Sumit Jolly · Answer

You want to replicate data from SQL server to ms access? Why can't client link directly with Sql server rather maintaining two dbs?