Rightyho, I am in need to set up an indirectly (offline laptop-usable) synchronising database system without access to run server side processes. It looks to already work, but for testing purposes only on 3 laptops at the present time (ultimate goal - 7 to 20). In the following way;
1. Design Master resides on a network folder
2. A replica of design master (affectionately called 'replica master') resides on a network folder. Replicas are created off this.
3. Local replica resides on the windows desktop of my laptop
4. The three above are managed by a synchroniser running on my laptop.
5. Other people also have synchronisers running - managing the Replica Master, and a local copy on their desktop.
6. Dropboxes are in folders on the network drive.
This should, in theory, work perfectly.
However, there are a couple of potential problems:
1. Is there a better way of achieving the above? For example, if I set 'other people' synchronisers to manage their local replica only, will it still update the replica master? Can I set my synchroniser to stop managing the Design Master, and start it again after any changes?
2. Can use of the 'Compact Database' function cause any loss of data when using replication?
3. At one point synchronisation looked very much like it got stuck in a loop, and the log file was filled up with entries like:
Time = 2007-01-22 04:00:40 PM
Log Type = Cancel exchange
Replica = \\afsukhofs02\[folder names here]\Replica master.mdb
Exchange ID = {661D4E31-ECD1-4250-8431-285F7F3A6FFC}
Reason = Synchronizer send failure
Time = 2007-01-22 04:00:41 PM
Log Type = This other synchronizer is also managing this replica
Replica = \\afsukhofs02\[folder names here]\Replica master.mdb
SynchronizerUK2 0302
I assume this is because every synchroniser is set up to manage the same file, but I hoped this would not be a problem. Is question 1 the answer to this problem?
4. The log file appears to become fairly large - is there a way to reduce the information stored in it? Is the only other alternative to stick a batch file shortcut in the startup folder to delete it?
1 1376 nico5038 3,080
Recognized Expert Specialist
I once started with replication, but wasn't really impressed. After reading the trouble it can cause (too old replica's can't be synchronized anymore, etc.) I reverted to coding my own im-/export function.
Probably most of your questions will be answered by the document you can download at: http://support.microsoft.com/kb/q282977/
In Access 2007 replication is no longer supported and you'll have to use a Sharepoint server or the new email send/receive mechanism to get this functionality.
Nic;o)
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: karl |
last post by:
I am currently investigating MS Access replication, my initial thought
is to use 'Indirect synchronisation' due to remote disconnected client
base. With this conclusion, I am presuming the 'Replication Manager',
which is part of the MOD edition will be required.
My only concern is that we will probably purchase a copy of Office
2003 MOD edition, and the Project itself will be developed in Access
2000 due to all clients using 2000....
|
by: Ray |
last post by:
Hi,
I have an Access 97 Database on the server, which gets updated from Desktops
thru a LAN. Employees who have to go to offsite locations, carry the latest
copy of the MDB. At the end-of-the day when they return to the office or
they send the copy of the MDB, the Laptop version (with their current
entries) has to be synchronized with the
MDB sitting on the server. How do I go about setting up this?
I would appreciate suggestions...
|
by: Andrew Chanter |
last post by:
I developed 3 different replicated database applications in MS Access for 3
different corporate clients in Access 97 several years ago to enable data to
be shared across wide area networks. I observed 2 issues that plagued all 3
systems.
1. the database files continually became corrupt during synchronization.
Most times this was easily fixed via a repair and compact, but the frequency
with which this occurred was of concern, and...
|
by: John |
last post by:
Hi
We have an access app (front-end+backend) running on the company network. I
am trying to setup replication for laptop users who go into field and need
the data synched between their laptops and the server upon return to the
office. I am planning it this;
Move all access tables to sql server and then link the tables to access
front-end mdb app (using odbc?). Copy the same setup (access front end + sql
backend) onto each laptop....
|
by: Raphi |
last post by:
Hi,
I've been using an Access application I wrote for an office with the
front-end stored on all computers and the back-end on one of them serving as
an Access file server.
Now we're moving to a 2nd office 15 minutes down the road. Only one office
will be open at a time, so theoretically it'd be possible to copy the
back-end manually every night from one office to another, but frankly,
that's pretty annoying.
| |
by: Rick |
last post by:
I'm running an Access2000 front end mde linked to an Access2000 back
end mdb. I need to set up replication and synchronization of only the
data tables between the master db on the pc and replicas on numerous
laptops.
I know that it can be done using the Access replication manager
(although without a simple UI in the front end mde), but the question
is:
If I link the FE to MSDE rather to Access, can I 1.) provide a more
|
by: David W. Fenton |
last post by:
See:
Updated version of the Microsoft Jet 4.0 Service Pack 8
replication
files is available in the Download Center
http://support.microsoft.com/?scid=kb;en-us;321076
This includes the Jet 4 synchronizer.
This allows anyone to do indirect replication, even without
|
by: Tatsuo Ishii |
last post by:
pgpool 1.0, yet another open source replication software for
PostgreSQL is now available at:
ftp://ftp.sra.co.jp/pub/cmd/postgres/pgpool/pgpool-1.0.tar.gz
pgpool is a single master/query based/synchronous replication
server. It acts as a proxy server between PostgreSQL client and
PostgreSQL server. No application change is needed to use pgpool.
pgpool's features include:
|
by: Alex |
last post by:
Hello,
We are currently running our Access 2003 database over Citrix. We have
been using a single front-end, but reading over topics in this group
has made it clear that I should create separate front-ends for each
user...so I will do so...thanks to this group for the great research.
My question: on occasions, staff have to access the database and they
will not have a network connection. I am considering setting up
replication...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |