i want to sync ms access database to sql server database using Microsoft Sync Framework

There is no Access - Sync Framework Provider (as far as I know), however you could eiterh create one using the Simple Provider Framework (that is part of Sync Framework), or you could use the existing SQL Server providers. What I mean by this is that you could move the data in your Access database to SQL Server (using the Access Upsizing Wizard) and then continue to use Access for your application (forms and reports) but Sync Framework would just sync the data from one SQL Server database to another.

Liam Cavanagh
Sr. Program Manager
Microsoft Sync Framework / SQL Azure

This may hel;p you

Using dt As New DataTable()
Using conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Documents and Settings/Administrator.RIEL/My Documents/Visual Studio 2008/Projects/WindowsApplication2/WindowsApplication2/mydb.mdb;Persist Security Info=True")
'Using cmd As New OleDbCommand(sql, conn)
Using cmd As New OleDbCommand([String].Format("select * from {0}", "Table1"), conn)
Using adapter As New OleDbDataAdapter(cmd)
cmd.CommandType = CommandType.TableDirect
cmd.Connection.Open()
adapter.SelectCommand.CommandTimeout = 240
adapter.Fill(dt)
adapter.Dispose()
End Using
End Using
End Using

Using conn2 As New SqlConnection("Data Source=SYS-DOT-NET-01;User ID=sa;Password=sql;Initial Catalog=dcc")
conn2.Open()
Using copy As New SqlBulkCopy(conn2)
copy.DestinationTableName = "demo"
copy.BatchSize = 1000
copy.BulkCopyTimeout = 240
copy.WriteToServer(dt)
copy.NotifyAfter = 1000
End Using
End Using
End Using