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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-20 : 08:37:28
|
| Connie writes "In SQL Server 2000 you can create a backup of a subscriber database and take it to another location for the purpose of adding another subscriber (using the NoSync option). Or so I have read! So my question is: can I do the same with a 'Microsoft Access' subscriber database? FYI-we have a Microsoft Access application consisting of a program mdb and 5 data mdbs. (130M, 180M, 505M, 660M and 400M) We are replicating all 5 data mdbs: 8 offsite locations syncing with an Internet replica (twice daily) and 8 replicas on a lan syncing with a hub every hour, which syncs with the Internet replica twice daily. Surprisingly enough, we have very few problems with our replicas, even tho they are quite large. And since the app is using unbound forms, the speed it is acceptable. But we know we are really pushing our luck, so we want to convert to SQL Server asap. Our goal is to convert the data to SQL Server and create Access replicas. (but just until we can rewrite the app using vb.net and/or asp.net)" |
|
|
|
|
|
Replicating to an Access subscriber