Re: MSDE replication experience

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Cheval (NoSpam.Ask_at_ForEmail.com)
Date: 01/19/05 

Date: Wed, 19 Jan 2005 21:58:44 GMT

I hope I am just reading this wrong, but are the users creating new replicas
*each* time they disconnect from the network? If so, they don't need to. It
only needs to be done once to get them a replica for use and then only
synchronize the data from then on.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
"Graeme Richardson" <graeme@wave_nospam.co.nz> wrote in message
news:csk29l$93t$1@lust.ihug.co.nz...
Hi, I have an installed A2003 application on a three computer network.
Data and code are split. Users creates editable replica of backend before
disconnecting from network and replicates on reconnecting.
I'm experiencing errors (along the lines of "too many tables open",
"MSysRepInfo already open") which I'm attributing to the replicated backend.
I'm hoping that upgrading the backend to MSDE 2000 will fix the problem.

Any opinions on what sort of headaches I'm in for?
Any examples of code that performs the replication will be appreciated.

Thanks, Graeme

Relevant Pages

  • Re: Intermittant 3167 error/indexing problem
    ... risk of corruption. ... Network drivers can get upgraded/downgraded. ... Indirect synchs between a replica that is being edited? ... The synch should only happen when the edited replica is ...
    (microsoft.public.access.replication)
  • Re: Intermittant 3167 error/indexing problem
    ... I just don't believe there's a whole network where all the users ... The synch should only happen when the edited ... replica is *not* being edited. ... running indirect syncs whilst the system is being used and records ...
    (microsoft.public.access.replication)
  • RE: Trouble wtith Synch Code
    ... replica if the laptop is connected to the network when the replica ... laptop is not connected to the network. ... I have this code that runs when the switchboard form opens. ...
    (microsoft.public.access.replication)
  • Code to initiate sync from replica
    ... sync to the master db on the company network. ... I'm trying to use the code below to initate the sync process from the ... replica (after connecting to the network the users would click a button ... Set dbTestCxn = DBEngine.OpenDatabase ...
    (microsoft.public.access.replication)
  • RE: Trouble wtith Synch Code
    ... replica if the laptop is connected to the network when the replica ... laptop is not connected to the network. ... I have this code that runs when the switchboard form opens. ...
    (microsoft.public.access.replication)