Access 2003 replicated database - Direct Method Stopped Working

[Raccess500]

We have an Access 2003 replicated database that has been working for
years. We use both Direct and Indirect Replication. The Direct
replication has stopped working. The pop menu from the tools menu/
Replication/Synchronize now menu does not display anymore. The
Indirect Replication still works fine, but the direct method has
stopped working. It’s disconcerting knowing that we now only have one
method to replicate.

To the sum this up, we need to get the direct synchronization to work
again. Do you have any ideas?

Rick

[David W. Fenton]

Raccess500 <racce...@aol.com> wrote in
news:082af861-0475-4838...@y11g2000yqm.googlegroups.co
m:

> We have an Access 2003 replicated database that has been working
> for years. We use both Direct and Indirect Replication. The
> Direct replication has stopped working. The pop menu from the
> tools menu/ Replication/Synchronize now menu does not display
> anymore. The Indirect Replication still works fine, but the
> direct method has stopped working. It's disconcerting knowing
> that we now only have one method to replicate.

How about direct replication in code? Does that still work?

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

[Raccess500]

You got me David. Here was my understanding. I thought using the pop-
up menu and selecting the “Synchronize Now” selection, that this was
Direct Replication; and then if I use a selection event from a form,
i.e. button, that kicks off replication in the code, that this was
“Indirect Replication”. Am I wrong in my analogy?
Is there a way via code to use an event and kick off first Synchronize
and followed by Replication? I know there are subtle differences
between the two.
Rick

On Jun 25, 6:55 pm, "David W. Fenton" <XXXuse...@dfenton.com.invalid>
wrote:
> Raccess500 <raccess...@aol.com> wrote innews:082af861-0475-4838...@y11g2000yqm.googlegroups.co

[David W. Fenton]

Raccess500 <racce...@aol.com> wrote in
news:3cd582dd-df19-4eda...@u7g2000yqm.googlegroups.com
:

> You got me David. Here was my understanding. I thought using the
> pop- up menu and selecting the "Synchronize Now" selection, that
> this was Direct Replication; and then if I use a selection event
> from a form, i.e. button, that kicks off replication in the code,
> that this was

Well, you do actually get the option to synchronize with a
synchronizer not just do a direct replication.

The point I was making is if this is a UI issue or if there's
something wrong with your replica preventing the synch.

Also, have you patched A2007? The original release had a bug that
prevented direct replication in code via DAO. I don't know that this
spilled over into the UI or not, but be sure you have the latest
version of A2007.

[Raccess500]

On Jun 27, 5:59 pm, "David W. Fenton" <XXXuse...@dfenton.com.invalid>
wrote:
> Raccess500 <raccess...@aol.com> wrote innews:3cd582dd-df19-4eda...@u7g2000yqm.googlegroups.com

I do not think it’s in the UI. I opened the Replicated database
separately, and I tried to use the available tools from the menu.
<Click> Tools <Click> Replication <Click> Synchronize now… the first
message is “There isn’t enough memory to perform this operation.
Close unneeded programs and try this operation again”. Then nothing
happens after that. When I go through this same process with a
database with no issues, I get the same message, but it follows with
the popup menu for Synchronize Database message.

I’m sure I did not download the patch, especially since we uninstalled
it.

Rick

[David W. Fenton]

Raccess500 <racce...@aol.com> wrote in
news:675a82e7-1797-43d0...@i31g2000yqm.googlegroups.co
m:

> I do not think it's in the UI. I opened the Replicated database
> separately, and I tried to use the available tools from the menu.

><Click> Tools <Click> Replication <Click> Synchronize now. the

>first
> message is "There isn't enough memory to perform this operation.
> Close unneeded programs and try this operation again". Then
> nothing happens after that. When I go through this same process
> with a database with no issues, I get the same message, but it
> follows with the popup menu for Synchronize Database message.

Sounds like something is definitely messed up in your Access
installation.

> I'm sure I did not download the patch, especially since we
> uninstalled it.

You don't need to download the patch any longer -- it was rolled
into SP1. If you've used Microsoft Update to keep your Office
installations patched, it should be installed. If it's up-to-date,
it should be at least SP2 (go to the orb and choose Access Options,
then Resources -- it's the last thing listed there).