SQL Server Performance Forum – Threads Archive
SQL Server Replication Problem with MS AccessHello SQL Gurus, I want to replicate SQL serer database with MS access database. the tables names are different in sql server and ms access but the structures are same. i cannot change the destination table name in the article. is it possible to change the destination table name in article so that i can give the names of the access tables there. Also there are 3 access databases. I hv created 3 linked servers for the 3 ms access databases. but data is not getting replicated. i hv tested it with one sql server database and 1 access database with same table names and same structure. it works fine but if the table names are diff in ms access and sql server then data is not replicated. Pls. help me out. this is very important for me. Thanks in advance,
In the Create Publication Wizard, at the Specify Articles screen, there is a build button […] on the right of each article which opens a dialog box, Table Article Properties – YourTableName where you can specify the destination table name and owner. Nathan H.O.
http://www.databasejournal.com/features/mssql/article.php/1490561 – data structures difference between MS Access & SQL server, for information. http://vyaskn.tripod.com/repl_ans5.htm – about setting replication between MS Access and sQL Server. HTH Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Thanks to all of you for replying. I tried to change the table name from the Table Article Properties but in that dialog box, the your table name is not enabled, so i didn’t able to change the table name.