Does anyone know hot to replicate SQL 2005 with MS Access?

__________________
Regards,

Sean Anderson

Yikes, someone can correct me if I'm wrong but I do not think it is possible. MS Access does not contain all of the SQL replication components.

========================
Scott Klein
Author of:
Professional SQL Server 2005 XML
Professional WCF Programming: .NET Development with the Windows Communication Foundation
Professional LINQ
========================

I second that. I would imagine that Access contains *none* of the replication components. Not to mention the fact that access is n0t "always on" so it would be hard to replicate it.

"Replication" to/from MS Access is going to involve creating some SSIS packages. You could create some scheduled jobs to run those packages.

-Peter