I have been working with the FE/BE concept in Access for years and never has any problems with this approach. That is until now. The problem has to do with user's creating objects in their local copy of the FE - primarily queries. The problem comes up when I have a new version to roll-out. In the past I have simply replaced their existing copy of the FE with the new version (using an automated tool). Everything has worked wonderfully - until now.
Now I have users who create their own queries which of course are stored in their local copy of the FE - the copy that I will wipe out when I replace with the new version of the FE. The question is, how do I save these user defined objects when I copy the new file to their machine. I am sure there must be a solution out there but I can't find it. Hopefully the solution will be easier to implement that it is to find. Thanks in advance for your help.
Now I have users who create their own queries which of course are stored in their local copy of the FE - the copy that I will wipe out when I replace with the new version of the FE. The question is, how do I save these user defined objects when I copy the new file to their machine. I am sure there must be a solution out there but I can't find it. Hopefully the solution will be easier to implement that it is to find. Thanks in advance for your help.