Synchronize Access db 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

SQL Server 2005 Forums

Transact-SQL (2005)

Synchronize Access db with Sql Server

Author

Topic

hdv212
Posting Yak Master

140 Posts

Posted - 2009-05-20 : 16:04:36

Hi
I have a access database in my client app and the same sql server database for webSite. Is there anyWay to synchrounize my client db (Microsoft Access) with Web db (Sql Server 2005) ?

Note : Also i want to handle this Synchroniziation, for example convert Text dataType to uniqeidentifier, ... .

Thanks

Vinnie881
Master Smack Fu Yak Hacker

1231 Posts

Posted - 2009-05-20 : 23:46:38

Here is a description of how to setup replication between a linked server and SQL.

http://vyaskn.tripod.com/repl_ans5.htm#sqljetsub

Success is 10% Intelligence, 70% Determination, and 22% Stupidity.
\_/ _/ _/\_/ _/\_/ _/ _/- 881

hdv212
Posting Yak Master

140 Posts

Posted - 2009-05-21 : 11:31:00

Thanks Vinnie881
but my access db is not subscriber only, actually it's first publisher (to send data to sql server) and second is subscriber (to receive new items inserted from web)
Any help ?

hdv212
Posting Yak Master

140 Posts

Posted - 2009-05-23 : 16:03:10

Any help ?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources