If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Find Unused Forms, Queries, Reports, etc
I inhereted a database from the previous IT guy. sigh I am pouring over this 100+ form, report, query database and I am starting to go more insane than I am right now.
Is there a way to see if there are forms, reports, or queries, that are currently unsed in a databse? I would like to trim the FAT off this monster, but I am afraid to remove anything to avoid a crash. Also, the database was not split so the data is here as well. I am in the process of splitting this thing right now. Thanks as Always, RIP |
#2
|
|||
|
|||
Find Unused Forms, Queries, Reports, etc
In access 2003, you can right click any query, or form or whatever, and it
will show you object dependences. However, it certainly can not, and does not work for code. I mean, in code you can go: strForm = inputbox("What form to open") docmd.OpenFrom strFrom So, dependences in code can't be resolved at all. If there is a lot of code in your application, then knowing that you have a query that is NOT used by a form, and is NOT used by report still does not mean you can get rid of the query..since code might use that query. There are thus some tools that can help you. For example, if you are in some code, and need to know what OTHER code routines call the current code you are in, then check out: http://www.mztools.com/ The above is a AMAZING free tool that has all kinds source code editing and aids to help you. There are also some commercial products that do help with some of the dependences searching, but often as showen above, you can resolve dependancies untill the code is run... ..... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.attcanada.net/~kallal.msn |
Thread Tools | |
Display Modes | |
|
|