Can I make replication work from Microsoft SQL Server and Microsoft Access?
You can set up one-way replication from SQL Server to an ODBC DSN, which can be a Microsoft Access database. SQL Server uses “publish and subscribe” replication where one database publishes, or replicates, information to subscriber databases. There’s no bi-directional heterogeneous replication available at this time – look for it in the next versions of Microsoft Access and SQL Server. • Why does my replica report that it has expired? How can I fix it? If your replica was created using DAO or the Replication Manager, the default expiration period is 60 days. If the replica set was created through the UI, the default expiration period is 1000 days. Unfortunately, the expiration date is not exposed to DAO. You need to use the Replication Manager to change the expiration date. If you don’t have the Replication Manager installed, you can always just open your Design Master and synchronize with the replica member, even though it reports it has expired. Of course, this will not work if you h
