Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Database replication with Access
0 views
Skip to first unread message
Bill
Jul 22, 2002, 2:58:38 PM7/22/02
to
What are the limiting criteria for using merge replication between SQL and
Access? Specifically, I would like to know what is the maximum Access 2000
database size that should be replicated with SQL Server 2000? When using
merge replication, the database grows substantially in size when the
replication fields are added along with the conflict tables. Are there any
guidelines as to how much bigger the replicated Access database will be?
Access? Specifically, I would like to know what is the maximum Access 2000
database size that should be replicated with SQL Server 2000? When using
merge replication, the database grows substantially in size when the
replication fields are added along with the conflict tables. Are there any
guidelines as to how much bigger the replicated Access database will be?
Are there any other recommendations for keeping data in sync between SQL and
Access 2000?
Thanks
Hilary Cotter
Jul 22, 2002, 3:21:13 PM7/22/02
to
This varies with the frequency of updates and the number
of tables you are replicating.
of tables you are replicating.
For larger applications I would suggest you port to MSDE
which has essentially the same SQL Server engine that
ships in the other SQL Server products. However MSDE is
limited to a 2G size of your data file (your mdf).
>.
>
0 new messages