Re: Update db FE with "power user"

Tom van Stiphout wrote:
On Thu, 19 Feb 2009 19:52:15 -0800 (PST), "robert.waters"
<robert.waters@xxxxxxxxx> wrote:


Perhaps the best strategy is to adopt his changes in the main program.
What's good for the goose... Or expand the functionality of the main
program to such extent that his kinds of customizations are no longer
needed.

You mentioned you are distributing an MDB. That is a Really Bad Idea
and should be replaced with an MDE. The companies' intellectual
property should not be available to anyone wanting a copy of it.

To do what you ask strictly speaking is not that easy: say we have a
query that you added a column to for the next release, and an updated
report depends on it. Your boss also modified the original query to
change a sort order. Even if you can detect that both of you have
updated the query, which version are you going to keep? This should
give your boss pause.

What should give the entire organization pause is that a rogue
employee is making changes that have not gone through the normal
alpha/beta testing cycle. You *do* have that process in place, right?
Since when do we take changes in production without these required
steps? Not even the President should be allowed to do that. Quod licet
Jovi, non licet bovi?

-Tom.
Microsoft Access MVP



I have an Access front-end that I make regular modifications to and
then distribute to many users on a terminal server using AutoFE
(thanks Tony!!).
However, I have one "power user" (My boss) that makes his own changes
to his copy of the FE (regardless of my attempts to get him to use a
separate copy of it).
Is there any code out there to intelligently update an mdb, not using
SourceSafe (we don;t have a license, and if we did I wouldnt want him
playing with it)?

I am looking for something to selectively update the objects in an
mdb, or synchronize from a master source without deleting custom
objects. I would like to avoid writing my own code, as this would
take some large amount of time (I wouldnt mind converting some already-
written-for-a-similar-purpose code though). I am not averse to
purchasing something reasonably priced, to eliminate the headache.

Thanks everyone.
Maybe you could appease the boss by giving him his own front end that only has links to the back end. that way he can create whatever queries and reports he wants and keep them forever.

Of course, you would probably want to limit him to read only. You could likely do that by hiding the table links and only giving him access to queries that are snapshots. Course, it is not fool proof.

bob
.

Relevant Pages

  • Re: Update db FE with "power user"
    ... You mentioned you are distributing an MDB. ... Your boss also modified the original query to ... take some large amount of time (I wouldnt mind converting some already- ...
    (comp.databases.ms-access)
  • Re: Official Status of SQLServer 2005 ADP
    ... "remains with Jet and linked tables or remains with Jet ... but go with SQL pass-through queries and unbound forms" ... RecordSource is a query with a where clause that limits the number of rows ... > queries under MDB was bad and worst than the one offered by ADP while you ...
    (microsoft.public.access.adp.sqlserver)
  • Exploding query text
    ... I have an app that's using DAO to automatically add some queries to an .mdb ... write my SQL Jet seems to rewrite the SQL sometimes creating a much, ... Here's an example of 2 queries that my app is creating using DAO that do the ... To me, the 2nd query is ...
    (microsoft.public.access.queries)
  • Re: Update db FE with "power user"
    ... Your boss also modified the original query to ... queries that are snapshots. ... he doesn't lose any of his custom objects (generally forms, queries, ...
    (comp.databases.ms-access)
  • Re: Update db FE with "power user"
    ... Bob Alston wrote: ... Your boss also modified the original query to ... You could likely do that by hiding the table links and only giving him access to queries that are snapshots. ...
    (comp.databases.ms-access)