MDB Search Tools

[Dave]

Are there tools that would allow me to search MDB queries & tables for a
variable\value?

Ex: I have used the condition " equals Typical" in queries. Now I have
close to a hundred queries. Finding the one with this condition is hard.

A find and replace for this condition would be helpful.

Ex: "equals Typical" would become In ("Typical","Other")

I have searched the Internet and have seen a couple, loaded them without
what I am looking for. I am hoping someone else like me has already
discovered a way to do this.

Thanks

Dave K

 

[Guest]

We use a tool called Speed Ferret. (http://www.moshannon.com/) I think it
will do everything you're looking for.

Barry

 

[Larry Daugherty]

If I understand your need correctly then one of the most apt solutions
is a shareware product named "Find and Replace" from Rick Fisher at
www.rickworld.com

There are some commercial products out there as well. The only one
whose name I readily recall is Speed Ferret from www.moshannon.com

HTH

 

[David F Cox]

This is where an integrated data dictionar would be very welcome. A "where
used" facility for field names would be a godsend. The sad thing is that
Access already has this facility built in for its own internal use.

 

[Nick Coe \(UK\)]

I've been using Speed Ferret for some years now. Highly
recommended.

http://www.moshannon.com

--
Nick Coe (UK)
http://www.alphacos.co.uk/




In Dave typed:

 

[Bill Mosca, MS Access MVP]

I use V-Tools freeware at www.skrol29.com. It has proven to be completely
reliable in doing a deep search and replace on all objects and code.

 

[William Hindman]

....I love Speed Ferret but they take forever to get updates out ...they've
been promising a A2K3 version for years now. I switched to F&R and then to
V-Tools which I'm pleased with.

William Hindman

 

[Dave]

Thank you everyone!!!

The information is very helpful

Dave

 

[aaron.kempf]

what a bunch of flamers

MDB is for babies.

if you used SQL Server; and Access Data Projects you could have real
search capabilities; either fulltext search; or an enterprise level
database search tool; like DTSearch-- which is a great 3rd party
product.

-Aaron

 

[aaron.kempf]

sqlserver has syscolumns for example

This is where an integrated data dictionar would be very welcome. A "where
used" facility for field names would be a godsend. The sad thing is that
Access already has this facility built in for its own internal use.

 

[Nick Coe \(UK\)]

Very true. In their defence I've formed the impression that
they prefer to deliver a solid, well tested tool rather than
quickly produce something a bit buggy. Having said that, it
is taking a long time as you say. Mind you, I'm a fine one
to talk since I've not got around to doing anything with
AccHelp for some time...

Thanks for posting those alternatives - especially V-Tools.
Most interesting.

--
Nick Coe (UK)
http://www.alphacos.co.uk/




In William Hindman typed: