matavai
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.