Has anyone (other than Luke and FMS) created a "compare objects in a
database" program to identify, mark, and transfer revised objects (queries,
forms, reports, classes, modules....)?
I know VSS is available, but for me it would be dificult because my target
and development environment are on my client's (closed) system. It also
That said, Tony (among a few others, but I use his) has an AutoFE Updater
program that works excellent. Store the active version of the FE (and any
files that go with it) on the server, and his startup app will copy over any
nonexistent or more recently updated files to the users FE location. This
happens every time they start the app and works seamlessly. Not to mention
that deploying the app is easy. Just copy the new FE over the old one in the
server folder and you're done.
"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)
I am using Tony's AutoFE...Thank you, Tony!
The issue is that I might have a couple three sandboxes working at once.
Each sandbox is associated with a particular subproject or problem I'm
investigating. I might also fix a small issue quick like a bunny and put it
in production, obsoleting the particular form, query, or module I fixed
within all the extant sandboxes.
I wish I could afford VSS or something like it. Thought maybe there was a
free or cheap one around that tracks just the objects within the FE.
I learned, for example, that when you turn on automatic name tracking, it
sets EVERY object's last update date to now(). Nice. I usually move
everything I've been working on into production every Friday or so. I can use
the modified date to identify those I've worked on, but not this
>That said, Tony (among a few others, but I use his) has an AutoFE Updater
>program that works excellent.
JimS <Ji...@discussions.microsoft.com> wrote:
>I am using Tony's AutoFE...Thank you, Tony!
Thanks for your kind comments.
BTW I've setup a testimonials page at my website and I've include both
of your comments on it.
http://www.autofeupdater.com/pages/testimonials.htm I hope you don't
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/