I am trying to set up a linked database between 3 different users and we are unable to modify the data between those 3 databases. For example user 1 wants to modify the data in one of the tables of user 2 but that is not possible. We do not know how to alter it from the query. Is there anybody out there who can help us?
I'm not sure I understand your situation. Do you actually have three separate databases? If so, can you combine them into one back-end database? Then you could link the users' front-end databases to it.