My question is how can I update a users FE (new release) without loosing any query or reports that the user has created in the current FE (old release)? Any suggestion would be appreciated.
Wow, I sure wouldn't let my clients monkey around with my front end. Invite them to create their own mdb and connect the the back end and work with that. If you're feeling nice you might offer to create that new one for them and import from your front end all of their custom objects. Then they could go from there.
Failing that I think you will have to write code to apply the modifications so that theirs are left alone. Of course if they've modified one of your objects, well, all bets are off. "The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"
actually, in the course of events of any old mdb, you cannot realistically expect users to NOT modify (e.g. add / edit / delete) objects. i rather think of the db stuff as theirs - not mine, so the 'suggestions' are quite welcome (even necessary).
the trick - reasonably found and discusseed here-in (tek-tips ms. a "fora" are extensively discussed and even fairly well coded. try advanced find with various key word combos, including 'Front end', update, MSysObjects (yes dorothy the funny hidden system table) et al.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.