automatically synchronization with sql server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

automatically synchronization with sql server

Author

Topic

asifbhura
Posting Yak Master

165 Posts

Posted - 2011-10-31 : 03:49:03

Hello

I have ms access, which is having around 20 tables,

with same structure, i have some tables in my sql server 2008 r2.

Now, end users is using ms access to enter data and update data.

I want to auto synchronize these data to sql server, whenever changes made in ms access..

question 2.

same auto synchronization, i want with sql server to sql server

but on remote server..

Regards

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-31 : 04:34:02

you need to set up linked server between access to sql server or between sql servers for this

see

http://sqlserverpedia.com/blog/uncategorized/how-can-i-link-a-sql-server-database-to-ms-access-using-link-tables-in-ms-access/

for auto synchronisation add a job in sql server agent to do data refreshing and schedule it

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources