Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / March 2006

Tip: Looking for answers? Try searching our database.

Remote Synchronization

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Archidrb - 17 Mar 2006 22:22 GMT
I have a standard multi-user Access database with a backend, a design master
and a master replica.  Each user makes a replica of the master replica and
synchronized to the master replica.  I synchronize changes to the design
master also to the master replica.

I have four users that work from home and all user at least a cable modem
broadband connection.  It is very very slow for the remote users.  I am
looking for help speeding this process up.

My first thought was to severe the remote users constant connection to the
backend and allowing them to work until they are ready to update their work
to the main system.  When they want to take the data they have updated and
add it into the backend as well as capture data that other users have added
to the system.

I would like to keep the local users on the local system and only have the
remote users run the update.  Anyone got some suggestions how to do this?
Signature

Darren
BA-DBA

Larry Linson - 18 Mar 2006 02:53 GMT
You really need to find the sponsored newsgroup that deals with replication.
This one deals with MDB-Jet multiuser databases, not replicated databases.
It is, unsurprisingly, microsoft.public.access.replication and should be
accessible through the same online frontend you used to get here, if you
only scroll down a little deeper.

Larry Linson
Microsoft Access MVP

>I have a standard multi-user Access database with a backend, a design
>master
[quoted text clipped - 16 lines]
> I would like to keep the local users on the local system and only have the
> remote users run the update.  Anyone got some suggestions how to do this?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.