Is there any way so that whenever we insert data in Ms Access table then it will sync in MS SQL table. Table schema will be same in both database.
I have to do something so that data will sync from MS Access to MS SQL because both database are live.
If you have access to Access 2010, you can link to a SQL Server table as long as that table has a unique index such as a primary key.