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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Synchronize

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-08-27 : 07:56:12
Aris writes "Hi

I have an sql server database and I have 40 other win 2k server in other domine and all this 40 servers have 40 access database, which is the copy of SQL database. My problem here is I need to copy all records from SQL db to access db of 40 servers. What is the best method to implement this?

Thanks
Aris"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-08-27 : 13:06:49
DTS or linked servers would work.

Tara
Go to Top of Page
   

- Advertisement -