finding unused queries

[jmob]

I am trying to search all code in a MSAccess database to find out if a query(or all of my queries) are actually used.
An implementation that lists where they are used and located would be great, but I just need to list the ones that aren't used in record sources, combo boxes, listboxes, reports, ... etc.
Any helpful links are also greatly appriciated. I was not able to find much beyond looking through the record sources of forms.
Thanks!

 

[PHV]

Perhaps here ?

http://www.jrbarnett.freeserve.co.uk/mdbdoc.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[VicRauch]

There is an excellent commercial product named SPEED Ferret that will tell you just about everything about your database, and will make most changes for you too. It has paid for itself in saved time for me several times over.
There website:

http://www.moshannon.com/

 

[MichaelRed]

Finding 'thing' seems to be this spring ('semesters'?) hot topic. there are several threads in these fora, reecently - along with many others from times far past. A brief reciew of this available literature (use search -anyone?) would include referencse to several third party tools (re Speed Ferret) along with some limitations which are NOT overcome by any tool or set of tools I have seen to date.

Some obvious pitfalls noted in the available literature include:

[tab]do not find queries generated by code (embedded SQL)
[tab]do not properly account for external data sources(e.g. ODBC items)
[tab]do not find / reference foregin databases (Jet) databases opened in code
[tab]do not locate/document objects (particularly Queries and tables) which are referenced via building the object name in code and referencing object by name
[tab] ...


I am sure that there are MANY other / additional pitfalls and serious detours in the persuit of this galling grail. I am not attempting to discourage those on the quest, as 'the ____ Grail' is their persuit. Merely attempting to highlight a few of hte traps and snares which they WILL encounter if the persuit includes applications generated by moderatly accomplished individuals ...



MichaelRed

 

[jmob]

ALthough this is not a school project, I believe a small tool that checks everything should be of great interest to anyone who develops small databases/interfaces in MSAccess and wants to optimize their code. SPEED Ferret seems to be the best option, although I am still not going to pay for it. You would think Microsoft would have some better documentation on Access objects and accessing everything from objects to text fields within access.
I am still stuck at square 1, trying to develop my own tool to search everything.
thanks everyone