I've been charged with maintaining and updating an Access db that was
created by a non-programmer who basically pulled pieces out of a
similar project willy-nilly in order to get something up-and-running;
there are modules, forms, tables, and macros that I cannot find any
reference to (they seem to be orphans).
Does anyone have code to iterate through the project looking for orphan
objects, or recommendations on how to locate them without having to
check the datasource of each control on every form, relationship
between forms, function calls, etc..? That would be a monumental task,
and I have been instructed to not begin from scratch.
Thank you kindly,
Robert Waters
FMS Inc has such a program, if I'm not mistaken it's Total Access
Detective.
-Tom.
Thank you very much, Tom. I am guessing there wouldn't be anything
open source/freeware for this.
A registered version of Find & Replace (www.rickworld.com) will do it. (The free
version has this feature disabled)
It is not free, but very cheap. ($20US from memory)
Wayne Gillespie
Gosford NSW Australia
<robert...@gmail.com> wrote in message
news:1159049615.7...@b28g2000cwb.googlegroups.com...
Phil
<robert...@gmail.com> wrote in message
news:1159047112....@m7g2000cwm.googlegroups.com...