Data Replication From SqlServer DB to MS Access DB

Pnkl

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.....

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User12y ago
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?
Pnkl12y ago
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
Guest User12y ago
You want to replicate data from SQL server to ms access? Why can't client link directly with Sql server rather maintaining two dbs?