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 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?
I need some help in this area of Access programming. I want to create a List combo, whereby the user have to double click the record from the list to populate the a form. I will appreciate any good code. I have always enjoy this author coding and publishing article. (If this comment was disrespectful, please report it.)
1/9/2003 3:46:32 AM:
i developed a client server system using Microsoft Visual Basic 6.0 and the database is using Microsoft SQL Server 7.0.the system developed and be used in LAN environment was working sucessfully, but now how can i make the sql server data link to another sql server data at another place? What i mean is, how the data in sql server can be updated to other sql server data at another place. For example : at main office i have one sql server 7.0 database and having a client server system. when the data key in in main office, i want the data to update and send to branch office sql server database. The updated process maybe can be set every 2 or 3 hours. after the updated, the branch office can view the data as same as the main office data.. thank you.. (If this comment was disrespectful, please report it.)
nabil (If this comment was disrespectful, please report it.)
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular article, please
click here instead.)
7/11/2002 12:10:39 PM: 
