|
|
I am tying to put together a
form with buttons which will automate some of the routine replication
tasks that my client has been wrestling with. Where is the best place
to go for code examples which illustrate using DAO or JRO to do
synchronization? I'm looking for code which will overwrite the hub
replica data with the regional replica data. And then I'm also looking
for code which will produce new partial replicas.
|
| |
My
book Programming Microsoft Access
2000 includes a chapter on replicating databases. It features
ADO code samples for typical replication tasks, including creating
replicas, synchronizing replicas, and processing partial replicas. |
| |
My
anonymous replica are synchronizing over the web although I am sure that
I configured IIS correctly for Internet synchronization. What
causes this? |
| |
Anonymous
replica have a known synchronization bug. The fix is to install
Jet 4.0 SP 5. See detailed installation instructions at http://support.microsoft.com/support/kb/articles/Q239/1/14.asp.
This fix applies to both Access 2000 and Access XP. |
|
|
Your book has many fine programming database
replication samples, but I want more. Where's a good source? |
| |
A white paper (http://msdn.microsoft.com/library/techart/jrorep.htm)
contains many samples illustrating JRO programming techniques for
controlling replication. All the samples in the white paper are
available in a database file that ships with Microsoft Office Developer
(MOD). Go to the \ODETools\v9\Samples\Opg\Samples\Ch16 folder on
the MOD distribution CD for the database file. |
|
|
Can a table that I change to keep local have a
relationship with another replicable table? |
| |
No. In fact, you will not be able to make a table
local until you remove all its relations to other tables that are
replicable. If your application uses the relation, it will
fail. |
|
|
When I want to change the replicability of a table with
a Replica object's SetObjectRecplicability method, I use
"Tables" as the ObjectType argument, what string do I use when
I want to set the replicability of a query? |
| |
Use "Tables" as the ObjectType argument for both
queries as well as tables. |
|
|
How do I set programmatically the replicability of all
forms, reports, data access page links, macros, and modules? |
| |
Use the SetObjectReplicability method with a table name of
MSysAccessObjects. You can only use this technique to make the
Access objects in a project replicable before converting a database to a
design master. |
|
|
Does a replica with a read-only updatability setting
mean that the replica will not accept deletes from other replicas? |
| |
The Updatability parameter for the CreateReplica command
affects the ability of users to change a database's schema and
records. This means a user cannot delete a record. On the
other hand, a read-only replica participating in a replica set can
accept delete updates from other replica members during synchronization. |
|
|
A URL reference to a white paper on Internet
synchronization appears on page 448 in Programming Microsoft Access
2000. I cannot find the white paper at the URL. Where is it? |
| |
Go to http://msdn.microsoft.com/library/background/html/intrjet4.htm
for the white paper. This paper is chuck full of insider info on
database replication over the web with Jet 4. |
