Synchronizing
Jul 30, 2007When I synchronize my replicas not all the data is being updated. What would cause this and how can I fix this?
View Replies
ADVERTISEMENT
Replicas And Synchronizing
Dec 21, 2006hello. can anyone help me with replica conflicts?
i need to work with 10 replicas and synchronize with a master, but anyone can make changes and modify the records on the other replicas. is there a solution for that? why access doesn't recognize the changes as a conflict?
Thank you all.
Synchronizing Tables
Jan 26, 2006Hi,
I'm a student learning how to use Access for my class project (Information Technology in a Global Society), and I chose to work with databases (even though, frankly, I'm technologically challenged). I've already finished making a very elementary database (tables, form, and a macro or two), but I was wondering if there's any possible way to synchronize the material in each table in such a way that changing the information in one would automatically update information in the other.
(I have one main table, and several other sub-ones with the exact same information but only parts of the main table. By this, I mean I created a main table with every student's Extended Essay topics, along with their supervisor as another field. Each supervisor oversees an essay for several students, so I created sub tables for each supervisor with the information of only their students.) What I'd like to know is if I can keep one main table with every supervisor's information and separate tables for each supervisor -- while, at the same time, having the main table update with the information that's added to the sub-tables by the supervisors.
I considered using Relationships, but after going through the threads here concerning relationship issues...I got even more confused.
Any help would be greatly appreciated.
<3, Patti
Synchronizing Sub-Forms
Feb 12, 2006Hi, Could anyone please help me!
I am trying to create a sub-form which achieves the following.
When you select a vendor from a combo-box, only the software that is manufactured by that vendor appears in a data-sheet form view.
I have tried to create a secondary form which shows all the software and saved this. And then created another main form which has a combo-box for listing and selecting a software vendor. I have then dragged the secondary form into an area of the main form. Now i am just trying to figure out how to synchronize the two forms so that when you select a vendor, only software manufactured by the vendor is shown.
Synchronizing Combo Box
Mar 20, 2006How do I make the name appearing in my combo box to change to match the name displayed when the record navigation buttons are evoked. Currently, when I use the navigation button, the form scrolls to the next record, but the name in the combo box does not change to match the new record?
tx!!!
Problem With Synchronizing
Jul 16, 2007I have a database that is replicated and in my attempt to synchronize a message keeps popping up "Synchronization between replicas..... and ....... failed. The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
The problem is I don't know what field in what form or in which replica this is referring to. Please help!!!!
Conflict Errors When Synchronizing
Feb 14, 2006We have multiple users using the same database as local copies on each of their PC's. they are entering information in specifically assigned areas and no one is overlapping in their work areas. The users then synchronize to a master database that is on the network to transfer their info.
When synchronizing we are beginning to conflict errors, and the message is hard to decipher. Below is an example:
"Update/Delete conflict: Another replica also updated this record. This record lost the conflict. Either resubmit your update or delete the conflict record."
It then shows two columns. Column 1 has the option to "Keep exisiting data" an dcolumn two has the option to "Override with conflicting data".
Technically, when synchronization happens, data of the user who is synchronizing overrides existing data in the master database in the same record(s). In that spirit, what is the 'existing' and 'conflicting' data referred to in the message?
Synchronizing 2 Comboboxes (not The MS Northwind Style ...)
Sep 26, 2005Hi There,
I want to synchronize 2 comboboxes (actually 3, but let's start with 2)
On a form I have 2 comboboxes:
- CompanyType (FK fkCompanyTypeID in table Contacts)
- Category (FK fkCompanyCategoryID in table Contacts)
Let's say we have companytype CT1 until CT10.
For CT1, CT2 & CT3 I want to choose a catagory, so the combobox must be 'enabled'.
For CT4 until CT10 the Catagory combobox must be disabled, so that I cannot choose a category value.
Actually I want to choose 2 catgories (2 comboboxes) for CT1 until CT3.
But I think that an explanation for the example above is sufficient for me.
Both comboboxes are filled by a Select Query, and the values are filled in a separate table. (Table CompanyType (PK pkCompanyTypeID) & Table CompanyCategory (PK pkCompanyCategoryID)).
Can someone please help me on this issue? :confused:
Thanks in advance for your reply,
Greets,
Quinten
Big Trouble: Lose Data In Synchronizing
Oct 22, 2004This is very bad. We're losing data changes when we run a synchronize on an Access database.
A client wanted to use replication so he could have several people using the same database and then update everyone's changes. (It turns out that he's not used that feature.)
The client was unable to get the replica to work on his machine, so he uses the master version.
Instead, we've used replication to allow me to make changes in the database structure while he makes changes in the data. (Obviously, it would have been better to split the database in two parts, but it's too late for that now.)
Here's my process when I need to update his copy:
1. Synchronize between my master and replica.
2. Copy master to CD-R. (We're not on a network.)
3. Synchronize between client's master and replica.
4. Send a copy of master to client.
5. Open my new version of master on the client's computer and synchronize with his replica copy.
When we do that many of his recent changes disappear.
Why is that? They don't even show up as conflicts.
What are we doing wrong? Are we totally abusing the concept of replication or what??
I'm stumped. I appreciate any suggestions or thoughts.
Synchronizing Data Between Two Table Fields On A Form
Nov 22, 2004I have a form with a text box from a table (cus. ID) and when I input that cus.ID into that text box I would like for that data to be stored in the appropriate table (customer) and also in the bridge table (customer purchases). Is there any way to input the data once into a textbox on the form and have it recorded into two different tables? Please let me know. Thanks
View 1 Replies View RelatedForms :: Synchronizing Access Forms In Multi-User Environment
Dec 8, 2014I am developing a small database for use in a multi-user environment: I have split the tables off and am testing with two copies of the front-end on different machines. All seems to work well except on one form.
On this form, the value of a bound control (exposed as a number of radio buttons) is used to make related controls on the form visible or invisible. I use the AfterUpdate event to trigger appropriate VBA code to accomplish this; it works well.
However if two users have the same form open at the same record (unlikely, but not impossible), and User A changes the value of the control via the radio buttons, Access will eventually propagate the change to User B's copy of the form but the AfterUpdate event will not be triggered and the form becomes inconsistent. I understand that events are only triggered when a user makes a change to a control; how can I be alerted when Access makes a change?