Searching in MDB?

[Josh Grameson]

When developing it is many times necessary to search for a function name or
suchlike in all objects (queries, forms, reports) not just modules. The Find
tool does not seem to do this. Is there anything out there that will do this
for me?

 

[Sergey Poberezovskiy]

You can try to use my utility that takes the database and
splits it into textfiles. Then you will be able to search
within those. Take a look at:

http://www.compros.com.au/AS/ReadMe.html

Select Getting Started and download ASsetup.zip.

HTH.

 

[Douglas J. Steele]

Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html
Ucora: http://www3.bc.sympatico.ca/starthere/findandreplace/

 

[Josh Grameson]

Hi, and thanks for yor help.

I d/l your Database Splitter, and installed it. when I run it, and I tell it
to Retrive Objects I get an Error -
"Error loading type library/dll

 

[Sergey Poberezovskiy]

Which version of Access do you use?

-----Original Message-----
Hi, and thanks for yor help.

I d/l your Database Splitter, and installed it. when I run it, and I tell it
to Retrive Objects I get an Error -
"Error loading type library/dll


"Sergey Poberezovskiy"

 

[Sergey Poberezovskiy]

If you could just run it again, and this time do not try
to retrieve objects but select All checkbox and click on
process - you will most likely receive the same error
message, but the program should create an errors.log file
in the application directory. If you can just send the
context of this file for me to look at - I would greatly
appreciate that.

Regards,

Sergey

 

[Josh Grameson]

2000 and xp.

it also made it so that i could no longer access my mdb. so i uninstalled it
and now i can get back to mdb.

 

[Sergey Poberezovskiy]

You were unable to access your mdb because the utility
opened another (Automation) instance of Access and then
the database itself within that instance. If the
application terminates abnormally, the "orphaned" Access
instance prevents you from accessing the database.
Killing the process via the Task Manager will enable
access to the database even without uninstalling.

Regards,

Sergey.

 

[Josh Grameson]

awesome!!!
How is it that I have gone without something like this for 15 years!

thanks

 

[Josh Grameson]

I understand. But I restarted and this was not enought. I didn't bother
going to TM since there are some many things running it's hard to know
what's got what.