I invited Barry to share the demo Bank Genie database.
Barry received an email with:
George Kelly wants to share "bgdata" with you
He was invited to accept or decline the share.
He then clicked the link in the email and accepted.
The bgdata folder was automatically put into his dropbox on his computer.
He opened Bank Genie on his computer and was able to see the data.
He added a record.
I started Bank Genie on my computer.
I could immediately see the record he had added.
I added a record and closed Bank Genie.
He could see the transaction I had added.
That works perfectly.
Lets do a test to push it to the extreme.
What happens when two users add a record simultaneously?
We tried that test by phone.
We both started our Bank Genie and did a File>Open on the BGdata database in our respective Dropbox folders.
He entered data for a new transaction on his computer.
I did the same.
3-2-1 GO! We both added our transactions at exactly the same time.
He could see his new transaction but not mine.
I could see my new transaction but not his.
Reason? The changes had not yet been sent to the Cloud.
We both closed Bank Genie.
Barry received a message, I didn't.
We both restarted Bank Genie.
On his computer, his new transaction was gone, my new transaction was now visible!
On my computer, my new transaction was still there, his new transaction was not.
Conclusions:
- As a result of a simultaneous add, only one transaction was saved on the cloud (mine, perhaps because I was the Owner).
- Both our databases were again synchronised (we could both see my new transaction).
- Simultaneous adding MUST be avoided (meaning adding a transaction at EXACTLY the same time)
- Non-simultaneous adding works perfectly - where only one user ADDS records to the database at any moment in time
More testing is required of course