Re: movereplica query

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

From: Ian Burton (gbert_at_online.nospam)
Date: 12/10/04 

Date: Fri, 10 Dec 2004 11:54:29 -0000

Cheval,
Thanks for your advice. I was a bit confused by the first response.
I guess the answer is that for replication involving remote users, there is
no way round having to move a replica using file explorer, but as long as
that replica wasn't being managed, then it is ok for access 200 - which is
what we are using.
I would suppose that when I create a replica using replication manager, it
is not being managed by default in some way I don't know about?
Thanks,
Ian

"Cheval" <NoSpam.Ask@ForEmail.com> wrote in message
news:lPdud.66982$K7.33191@news-server.bigpond.net.au...
> Far out Peter! I've been using Office and Access from version 2 and that
> reply confused even me! Ian was only asking what other way is there to
> move
> a replica over a slow connection other than the replication tools, not
> "what's the conceptual theory of MS Access?".
>
> Ian, if you're using Access 97 then you're stuck. You can get in to too
> much
> trouble if you don't follow the rules.
>
> If you're using Access 2000 or higher, then I say make sure the replica
> isn't managed by anything, 7-Zip the replica and move the 7z file there
> and
> extract it. For exceptional cases like this, I'd take the risk of the
> replica getting corrupt. Just do it only in extreme cases like this. I've
> done it only in such extreme cases and had no problems at all, but then
> again, I'm a kinda "No guts, No glory" sort of person. You may be
> different.
>
> As always, the risk is yours and your mileage may vary... :)
>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>
> "Peter Yang [MSFT]" <petery@online.microsoft.com> wrote in message
> news:yVE%23uzn3EHA.2148@cpmsftngxa10.phx.gbl...
> Hello Ian,
>
> Your request is not support in builtin Access replication features.
> However, you may consider develop your own code to implement this.
>
> Use Jet and Replication Objects (JRO) (JRO: A set of automation interfaces
> that you can use to perform actions specific to Microsoft Jet databases.
> Using JRO, you can compact databases, refresh data from the cache, and
> create and maintain replicated databases.) if you require programmatic
> control over the exchange of data and design information among members of
> the replica set (replica set: The Design Master and all replicas that
> share
> the same database design and unique replica set identifier.) in Microsoft
> Access databases (Microsoft Access database: A collection of data and
> objects (such as tables, queries, or forms) that is related to a
> particular
> topic or purpose. The Microsoft Jet database engine manages the data.)
> (.mdb files only). For example, you can use JRO to write a procedure that
> automatically synchronizes a user's replica (replica: A copy of a database
> that is a member of a replica set and can be synchronized with other
> replicas in the set. Changes to the data in a replicated table in one
> replica are sent and applied to the other replicas.) with the rest of the
> set when the user opens the database. To replicate a database
> programmatically, the database must be closed.
>
> If your database was created with Microsoft Access 97 or earlier, you must
> use Data Access Objects (DAO) (Data Access Objects (DAO): A data access
> interface that communicates with Microsoft Jet and ODBC-compliant data
> sources to connect to, retrieve, manipulate, and update data and the
> database structure.) to programmatically replicate and synchronize it.
>
> You may want to see following article for more details:
>
> 258539 MOD2000: The Syntax for Synchronization Using Microsoft Jet and
> http://support.microsoft.com/?id=258539
>
> Thanks & Regards,
>
> Peter Yang
> MCSE2000, MCSA, MCDBA
> Microsoft Partner Online Support
>
> Get Secure! - www.microsoft.com/security
>
> =====================================================
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
> --------------------
> | From: "Ian Burton" <gbert@online.nospam>
> | Subject: movereplica query
> | Date: Thu, 9 Dec 2004 13:56:14 -0000
> | Lines: 14
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
> | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <uypIxbf3EHA.2676@TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.access.replication
> | NNTP-Posting-Host: creativeconsole-2.dsl1.easynet.co.uk 212.135.30.98
> | Path:
> cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12
> phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.access.replication:34150
> | X-Tomcat-NG: microsoft.public.access.replication
> |
> | Hi.
> | I understand that to create a replica, it is best to use replication
> manager
> | rather than file explorer, in order that it is done correctly, and
> avoiding
> | bugs, and weirdness.
> | What would be the strategy for creating a replica from the file server
> that
> | is going over a very slow WAN link? I think that if I replicate a 100MB
> | file over a slow link, it will take days, and most likely drop out and
> fail?
> | I am keen to create replicas not using file explorer, but at least that
> way
> | I can zip it up and send it to the remote office or burn it and send it
> via
> | courier.
> | Thanks for any advice you may be able to give me.
> | Ian Burton
> |
> |
> |
>
>

Relevant Pages