I have an access database that was replicated and synchronised. However some design changes were done to the Sync Master and now it wont synchronise. One is set as the Design master but they still wont synch. Also no one can tell me what the structure changes are, only that they are in the sync master nor the replicated file.
Now we can recreate the replicas and they will then sync but we will lose all the changes made in the current replicas. Access import, update queries and append queries all seem to solve one problem but create another.
We need:-
ideally.....
way of resynchronising with design changes and data
alternatively...
manual steps to achieve this
as a last resort....
once we recreate the replica a way of comparing the data so we know what has to be entered manually
please help !!!!!
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
* * *This broadcast message was sent to all bidders on Thursday Mar 20, 2008 5:06:07 AM:
could somebody pls explain to me the correct setup for a master and replicas We have a 'sync master' file that we want to sync replicas with 1 - do we create one replica and copy it for each user or do we have to create a new replica for each user 2 - does it matter if these replicas are moved 3 - does it matter if the replicas are renamed 4 - does it matter if the master is moved or renamed (obviously we will have to browse to new location/file to do the sync) 5 - should the Sync Master be the Design master or is this a 3rd file 6 - What is the correct method of applying design changes thanks
* * *This broadcast message was sent to all bidders on Thursday Mar 20, 2008 7:57:41 AM:
Hi Please note it is essential that the solution provided fixes this error that is a mandatory requirement of this bid Some coders are offering a report of design changes between the 2 databases. If I key in these changes then that must fix the problem. I am also worried that manual changes may result in an error that the history of design changes are different
* * *This broadcast message was sent to all bidders on Monday Mar 31, 2008 10:36:41 AM:
Hi I have uploaded and attached to the original bid copies of the two databases that will not sync as empty databases. Please view and inform me if you can assist tnx
* * *This broadcast message was sent to all bidders on Friday Apr 4, 2008 3:23:52 AM:
Hi any news please we are anxious to choose a cider tnx
* * *This broadcast message was sent to all bidders on Tuesday Apr 8, 2008 4:58:08 AM:
Hi I need to select a coder and finalise this bid. I have provided copies of the 2 databases to be synchronised. All I need is for you to find out the design differences that prevent them from synchronising, make them the same, ideally by altering the sync master, and let me know what they were. Just send be back 2 databases that sync and let me know what you had to change Thats It Please respond quickly
* * *This broadcast message was sent to all bidders on Monday Apr 14, 2008 3:48:27 AM:
No coders have replied so unless I hear otherwise I will assume you cannot do this and will re-issue bid to other coders
* * *This broadcast message was sent to all bidders on Wednesday May 7, 2008 4:46:56 AM:
Hi I am so anxious to complete this. I just need a really simple straightforward answer. The syncmaster and the replica are posted. I just need them to sync. Cant anybody do this !!??
## Platform
access 2000 xp