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
|
|||
|
|||
Searching mdbs for queries
Is there a way to search mdb files for query names from Windows Explorer?
-- Harry E Vermillion IT2 Division of Wildlife State of Colorado |
#2
|
|||
|
|||
Searching mdbs for queries
Harry
"...mdb files..." are Access databases/applications, and are self-contained. I'm not familiar with a way to use Windows Explorer to "look inside" Access ..mdb files to find query names. You've described more a "how" you want to do something. If you describe what you want to accomplish, the newsgroup readers may be able to offer an alternate approach. Regards Jeff Boyce Microsoft Office/Access MVP "Harry V" wrote in message ... Is there a way to search mdb files for query names from Windows Explorer? -- Harry E Vermillion IT2 Division of Wildlife State of Colorado |
#3
|
|||
|
|||
Searching mdbs for queries
Thank you, Jeff.
What I want to accomplish is to find a series of queries that are contained within an unknown mdb, somewhere on given hard drive. I know the names of the queries, but not the mdb, just the hard drive it resides on. Evidently, I can't do a string search on mdb's via Windows Explorer. There has to be another way, outside of the hindsight of tracking. -- Harry E Vermillion IT2 Division of Wildlife State of Colorado "Jeff Boyce" wrote: Harry "...mdb files..." are Access databases/applications, and are self-contained. I'm not familiar with a way to use Windows Explorer to "look inside" Access ..mdb files to find query names. You've described more a "how" you want to do something. If you describe what you want to accomplish, the newsgroup readers may be able to offer an alternate approach. Regards Jeff Boyce Microsoft Office/Access MVP "Harry V" wrote in message ... Is there a way to search mdb files for query names from Windows Explorer? -- Harry E Vermillion IT2 Division of Wildlife State of Colorado |
#4
|
|||
|
|||
Searching mdbs for queries
Harry
You could consider picking up one of the "analyzer" programs available for Access (paid ones include FMS, Inc's Total Access Analyzer, or Black Moshannon's Speed Ferret). These should give you a way to search for a query inside the .mdb files ... but you'd probably need to do this for each one. Regards Jeff Boyce Microsoft Office/Access MVP "Harry V" wrote in message ... Thank you, Jeff. What I want to accomplish is to find a series of queries that are contained within an unknown mdb, somewhere on given hard drive. I know the names of the queries, but not the mdb, just the hard drive it resides on. Evidently, I can't do a string search on mdb's via Windows Explorer. There has to be another way, outside of the hindsight of tracking. -- Harry E Vermillion IT2 Division of Wildlife State of Colorado "Jeff Boyce" wrote: Harry "...mdb files..." are Access databases/applications, and are self-contained. I'm not familiar with a way to use Windows Explorer to "look inside" Access ..mdb files to find query names. You've described more a "how" you want to do something. If you describe what you want to accomplish, the newsgroup readers may be able to offer an alternate approach. Regards Jeff Boyce Microsoft Office/Access MVP "Harry V" wrote in message ... Is there a way to search mdb files for query names from Windows Explorer? -- Harry E Vermillion IT2 Division of Wildlife State of Colorado |
Thread Tools | |
Display Modes | |
|
|