Group:  Microsoft Access ยป microsoft.public.access.replication
Thread: Cannot set indirect dropbox

Geek News

Cannot set indirect dropbox
leicklda <dkimbrell[ at ]wowway.com> 10/29/2008 3:05:02 PM
Been working with TSI for awhile now trying not to clog up the boards
with too many novice questions, but I'm really stuck here.

I do not have Replication Manager, nor do I have access to it, so I'm
trying to do an indirect synch with TSI alone. I am using Access 2003
& have installed the Jet4.0 & TSI 4.0 dll/exe files, and set
references in VB and added the registry key.

I've successfully created a replica and done a direct synch using TSI
commands in VB (synch.makereplica and synch.synchdirect), so I'm
fairly certain I have all the dll's installed & registered correctly.

I am trying to execute the following one-time code to assign a dropbox
to the local synchronizer and to have it register a local replica:

Dim Synch As Synchronizer
Set Synch = New Synchronizer
Synch.Running = True
Synch.IndirectDropbox = "C:\BlinkDrop"
Synch.ManagedReplicas.Append "C:\database\bsysdata.mdb"
Synch.Running = False
Set Synch = Nothing

The synchronizer opens fine (as it did when I performed the
makereplica and directsynch), but when the code gets to
"Synch.IndirectDropbox = "C:\BlinkDrop"", it halts with the error

-2417216501 (8004138b) - The operation has failed.

I'm baffled by this because this seems like such a simple step -
simply assigning a dropbox location.

Does anyone know what might be going on here?
Re: Cannot set indirect dropbox
leicklda <dkimbrell[ at ]wowway.com> 10/29/2008 3:16:40 PM
Another note: I made sure that my dropbox (C:\blinkdrop) IS a shared
folder. I thought maybe JET checked for that shared status necessity
before assigning the folder.
Re: Cannot set indirect dropbox
leicklda <dkimbrell[ at ]wowway.com> 10/29/2008 5:42:26 PM
I've been searching the Internet and found another one of David
Fenton's informative posts (thanks again David!) that showed me where
to find the registry entry for the dropbox location. I changed the
registry value (Transporter>FSAddress) to my dropbox directory and
that seemed to work. I ran the above one-time code again, eliminating
the synch.indirectdropbox line and my replica was added to the Managed
Replicas with the synch.managedreplicas.append statement with no
problem. Then just for kicks/troubleshooting, I tried to changed the
dropbox directory via code again, and again it failed!

I can change the dropbox location through the registry but not through
code. I don't get it.
Re: Cannot set indirect dropbox
"David W. Fenton" <XXXusenet[ at ]dfenton.com.invalid> 10/30/2008 3:19:41 AM
leicklda <dkimbrell[ at ]wowway.com> wrote in
news:00a31b2c-98c0-408c-a849-6c3b526451b0[ at ]l64g2000hse.googlegroups.co
m:

[Quoted Text]
> Been working with TSI for awhile now trying not to clog up the
> boards with too many novice questions, but I'm really stuck here.
>
> I do not have Replication Manager, nor do I have access to it, so
> I'm trying to do an indirect synch with TSI alone. I am using
> Access 2003 & have installed the Jet4.0 & TSI 4.0 dll/exe files,
> and set references in VB and added the registry key.
>
> I've successfully created a replica and done a direct synch using
> TSI commands in VB (synch.makereplica and synch.synchdirect), so
> I'm fairly certain I have all the dll's installed & registered
> correctly.
>
> I am trying to execute the following one-time code to assign a
> dropbox to the local synchronizer and to have it register a local
> replica:
>
> Dim Synch As Synchronizer
> Set Synch = New Synchronizer
> Synch.Running = True
> Synch.IndirectDropbox = "C:\BlinkDrop"
> Synch.ManagedReplicas.Append "C:\database\bsysdata.mdb"
> Synch.Running = False
> Set Synch = Nothing
>
> The synchronizer opens fine (as it did when I performed the
> makereplica and directsynch), but when the code gets to
> "Synch.IndirectDropbox = "C:\BlinkDrop"", it halts with the error
>
> -2417216501 (8004138b) - The operation has failed.
>
> I'm baffled by this because this seems like such a simple step -
> simply assigning a dropbox location.
>
> Does anyone know what might be going on here?

I'm not sure why it's failing, but your dropbox *is* invalid, as it
won't be accessible from another computer. You need to define a
network share for your dropbox and give *that* to the synchronizer.
It would be of the form: \\PCName\ShareName".

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Re: Cannot set indirect dropbox
"David W. Fenton" <XXXusenet[ at ]dfenton.com.invalid> 10/30/2008 3:20:42 AM
leicklda <dkimbrell[ at ]wowway.com> wrote in
news:564076b7-1cef-4d71-b5c5-ac4414a417c3[ at ]y21g2000hsf.googlegroups.co
m:

[Quoted Text]
> I've been searching the Internet and found another one of David
> Fenton's informative posts (thanks again David!) that showed me
> where to find the registry entry for the dropbox location. I
> changed the registry value (Transporter>FSAddress) to my dropbox
> directory and that seemed to work. I ran the above one-time code
> again, eliminating the synch.indirectdropbox line and my replica
> was added to the Managed Replicas with the
> synch.managedreplicas.append statement with no problem. Then just
> for kicks/troubleshooting, I tried to changed the dropbox
> directory via code again, and again it failed!
>
> I can change the dropbox location through the registry but not
> through code. I don't get it.

If you set it to C:\BlinkDrop in the registry, you'll have
non-functioning indirect replication, as that dropbox won't be
accessible from any other PC.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net