Link to home
Start Free TrialLog in
Avatar of matavai
matavaiFlag for New Zealand

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?
ASKER CERTIFIED SOLUTION
Avatar of jerryb30
jerryb30
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial