Update Rules & Examples

Because of performance and data integrity issues, Team Connect Online (TCO) is NOT designed to allow database activity (either queries or updating) to take place right on the web. The #1 design criteria for Team Connect Online is to ensure that a customer's database does not get corrupted or "stepped on" by other users.

The Team Connect Online Administrator for the team initially uploads a copy of the team's database to the Team Connect Online server from their desk top and then assigns "read" and "edit" rights to various users. Click Here for information about Admin Tools for Team Connect Online.  Let's discuss a couple of scenarios to see how Team Connect Online works.

Example 1 - Two Users on Read-Only Mode

User 1 logs on Team Connect Online for the first time. Team Connect Online will let User 1 know that they will need to download the database to their desk top in order to use it just as they would any other TEAM MANAGER Database.  After the download has been completed, User 1 can run reports and even make changes to the database.  But since they were not given "edit" rights, any changes to the database WILL NOT be uploaded to the Team Connect Online server.

User 2 logs on Team Connect Online for the first time and goes through the same procedure as User 1.  

When they are finished using their TEAM MANAGER, then they exit normally.  The next time they start TEAM MANAGER and logon to Team Connect Online, Team Connect Online will check to see if any changes have been made to the Team Connect Online copy of the database since their last download.  If no changes have been made to that copy, then it is not necessary to download it to the User desk top and they can proceed normally.  If changes have been made to the Team Connect Online server copy, then Team Connect Online will prompt the User to download that copy to their desk top.  

Please Note: If User 1 has made changes to their desk top copy of the database and then subsequently downloads a current copy of the Team Connect Online database, those changes will be over written.

Example 2 - One User in Edit Mode and One User in Read-Only Mode

User 1 logs on Team Connect Online and chooses the "For Edit" option (assuming the Team Connect Online Administrator has given edit rights to User 1).  When the "For Edit" mode is chosen, Team Connect Online will ALWAYS download the current Team Connect Online server database copy to the desk top to ensure that changes made on the desktop will have the Team Connect Online baseline.  Otherwise, multiple users could upload a database to the Team Connect Online server that was not based on the current Team Connect Online server copy.

User 2 logs on Team Connect Online and notices that the "For Edit" option is grayed out. Team Connect Online will display the User name of the person who has the database "locked for edit" so that User 2 can contact them to see how long they intent to spend making those changes.  Of course, User 2 has the option to login as "Read Only" and run reports, etc on the current database.

User 1 adds three new athletes and corrects the mailing address of two others then either logs off Team Connect Online or exits TEAM MANAGER.  TM will let them know that they had opened the Team Connect Online database in edit mode and asks if they want to upload their desk top copy to the Team Connect Online server.  User 1 chooses "Yes" and a new updated copy of the team's TEAM MANAGER database is uploaded to the Team Connect Online server.  Any user logging on to Team Connect Online after the User 1 copy has been uploaded will get that new copy.

Example 3 - How a User Might "Lose" Changes

User 1 logs on Team Connect Online and chooses the "For Edit" option (assuming the Team Connect Online Administrator has given edit rights to User 1).  When the "For Edit" mode is chosen, Team Connect Online will ALWAYS download the current Team Connect Online server database copy to the desk top to ensure that changes made on the desktop will have the Team Connect Online baseline.  

User 1 wants to add 10 new athletes but gets a telephone call and has to leave for a few hours.  So far, User 1 had added 3 of the 10 new athletes so they exit TEAM MANAGER and says "No" to upload the changed copy of the Database since they are not finished.  They return in 3 hours, start TEAM MANAGER, Login to Team Connect Online "For Edit", and now the current Team Connect Online server copy is download to their desk top and over writes their copy that has the 3 new athletes.  Now they must start over to add the 10 new athletes.

The point is that whenever the Team Connect Online database is opened "For Edit" and changes are made to the database, it is very important to make sure that when you logoff Team Connect Online or exit TEAM MANAGER, you choose "Yes" to upload those changes to the Team Connect Online server.