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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-25 : 08:20:28
|
| gradan writes "Hi all,I am new to this site and SQL server. here is my question, can i synchronise any changes in SQL server database (example DB name is Employer)to reflect on MS Access version of the same database(Employer database in access). this will save time in not exporting and importing database across regions on other officesCheers,gradan" |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2006-01-25 : 12:25:59
|
| Are you talking about database schema or data itself?It sounds like these Access database are stand alone, instead of linked to SQL Server. For linked Access database, the data should be in synch live.Is there only one instance of the Access in question here? |
 |
|
|
mblythe
Starting Member
16 Posts |
Posted - 2006-01-27 : 11:58:59
|
| In SQL Server 2000 it is possible to replicate data from SQL to Access using merge replication. There is a small amount of info here: [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replhet_93ar.asp[/url]. Basically you create a publication on the SQL side and a heterogeneous subscription for Access in which you specify a driver or provider to use when connecting to Access. This functionality is discontinued in SQL Server 2005.Michael Blythe Technical WriterSQL Server Replication - Microsoft --------------------------------------------------------------------------- This posting is provided "AS IS" with no warranties, and confers no rights. |
|
|
|
|
|
|
can i Synchronise SQL server database with MS Access