Replication group

[Guest]

There used to be a whole group dedicated to replication. Is it still around?
If so, where can I find it?

I want to know how I can program a button on a switchboard to let users
synchronize their data.

 

['69 Camaro]

Hi, Michael.

There used to be a whole group dedicated to replication. Is it still

around?

Yes. It doesn't get much traffic, so it's not listed as one of the
discussion groups for the Microsoft Office Online Communities.

If so, where can I find it?

If you use a newsreader, then see whether your ISP carries the newsgroup.
Otherwise, one may find recent messages posted on the Web here:

http://groups.google.com/groups?hl=en&lr=&c2coff=1&group=microsoft.public.access.replication

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[John Vinson]

Hi, Michael.

around?

Yes. It doesn't get much traffic, so it's not listed as one of the
discussion groups for the Microsoft Office Online Communities.


If you use a newsreader, then see whether your ISP carries the newsgroup.

Or, set the Newsreader to use msnews.microsoft.com as the News Server.
Just how to do this varies with the software you're using.

Otherwise, one may find recent messages posted on the Web here:

http://groups.google.com/groups?hl=en&lr=&c2coff=1&group=microsoft.public.access.replication

You can actually post from Google; it's almost as bad as the MS
website though, and posts are often several hours delayed.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

You weren't kidding when you said it doesn't ge much traffic... if
replication isn't used that often what method do Access users use in
multi-user environments? What about offline situations? Is replication the
only way to go?

 

['69 Camaro]

Hi, Michael.

if
replication isn't used that often what method do Access users use in
multi-user environments?

To avoid problems in a multiuser environment, the database should be split
into a front end and back end. The back end should reside on the network
shared directory and contain the tables and relationships. A copy of the
front end, which contains all other database objects and links to these
tables, should be placed on each user's workstation, so that they can all
share the data. For more information on splitting databases, please see the
following Web page:

http://www.Access.QBuilt.com/html/gem_tips.html#SplitDB

What about offline situations?

Replication can be used in offline environments, but we don't recommend
using Access replication for this. Perhaps another replicable RDBMS is
available to you? Access can be used as a front end to link to the tables
in another RDBMS that controls the replication.

Is replication the
only way to go?

No. It depends upon the needs of the organization and how the members of
the organization want to utilize and store the data. Most organizations do
not use replication. However, some organizations just don't have the
flexibility to use anything but replication to sync the data from disjointed
facilities.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Guest]

I am having the same kind of problem!

I am using Access 2002 to replicate a master database.

I have two traveling sales reps using laptops and a base station at the
office. I am having the two reps synch their laptops and some older data
fields are not replicating to the master.

For example, we have a customer that we have had contact with and we update
the memo field on the laptop. This field will not update on the master and
therefore not replicate out to the other sales person. We become out of sync.

Other fields synch up just fine.

The behavior is inconsistent.

Any ideas or help.

Microsoft want $245.00 to solve this problem which seems to me to be a bug
of theirs.

If there is a better way to sync these databases, I am open to it!!