Access Spilt database changing forms & queries

I've probably made a mistake here but I'm new to split databases.  I split it a couple of weeks ago & all is running well.  Since the split I've written a few queries in my version of the front end, & I think one other user has written a query in his front end.  

From what I've been reading this means we now have two different front ends & if I now make form changes to my version of the front end that I want to copy across to everyone else, this means the other user will lose his queries.  

I assume I can backup his modified front end & then copy & paste his queries into the new master version.

I think the normal solution is to provide other users with a compiled version so they can't make changes.  If I don't want to do that, I just have to declare a rule that anyone who wants to write a query has to do so in my 'master' version (in general I like my small number of users to be able to write their own queries if they know how, less work for me & allows them freedom of enquiry).

So there's no real question here other than - is what I've said above correct?
Who is Participating?
jerryb30Connect With a Mentor Commented:
It is called configuration management.  If users want to make queries, all well and good. If they want to integrate them into what everybody else is using, they do need to know that it has to be through the owner of the master database.
If those queries can affect the data others use in the back end, then you have a problem anyway.
So, from my viewpoint, you have stated it properly.
Please wait for input from experts.
Gustav BrockConnect With a Mentor CIOCommented:

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.