Tracking of folder & filenames in synchronization dialogue

[Dan]

Good day,

I am curious as to how one can delete the history of filenames associated
with synchronization. I am using Windows XP and Office XP/2002.

When syncing a Replica and a Master, in the dialogue box named 'Synchroizing
Database <name of database>', option Driectly with Replica there is a drop
down with paths and filenames so one does not have to browse for the desired
path each time. How can that be cleared, deleted, edited, reset? Pressing
Delete on the keyboard only clears the entry, not the drop down history
list. Where are the strings stored? In a file or the registry?

I tried searching the registry for a partial on one of the strings (the
computer name on a networked path) and came up with nothing. Looking
through the Applicationa Data path on my user ID yielded nothing either.

Like history tracking of filenames under Recent Documents and the file menu
panel of each application, I would expect that the values would evolve as
one uses different paths. However, mine does not change. I have 8 entries
in there and they have not changed in three years. Only two are relevant to
PCs still in this workgroup.

Thanks to anyone who can help.

 

[Tom Wickerath]

Hi Dan,

I found a reference in the registry that looked promising, with this path by
creating a replica with a name that I was not likely to have used before (I
used "Dogfood.mdb"):

[HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Common\Open Find\Microsoft
Access\Settings\Location of New Replica]

However, deleting this key and restarting Access 2002 did not remove Dogfood
from my recent replicas listing. It turns out that this data is stored in a
normally hidden system table in the database: MSysReplicas

As a user, you are not allowed to edit the data in this table directly.
While testing, I found that if you attempt to synchronize with a missing
database, you will get the following error message:

"Microsoft Access can't open the database 'FullPathToDBName'.
"Could not find file 'FullPathToDBName'.

where 'FullPathToDBName' included the full path to the Dogfood.mdb database,
in my case. This is followed by another informational message:

"Microsoft Access has deleted 'FullPathToDBName' and removed it from the
replica set."
"This change isn't reflected until the database is closed and reopened."
"Please close and reopen the database when you are finished synchronizing
replicas."

Upon closing and re-opening, indeed, Dogfood.mdb is no longer present in my
Tools | Replication listing. Curiously, the records are still present in the
MSysReplicas table, however, this time I noticed the value 16 entered into a
field named "Removed" in this table. So, I guess the answer is to attempt to
synchronize with the older filenames shown in your listing, in order to
remove them.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________