• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 373
  • Last Modified:

Recommendations for utility to search multpile Access databases?

Hello - can anybody recommend a decent tool that will search multiple Access mdb's/accdb's for a given table or query name, or a text fragment in VBA code?

Thanks
0
mlagrange
Asked:
mlagrange
  • 2
1 Solution
 
Dale FyeCommented:
I don't know of one that will search multiple db's at a time, but my favorite is Rick Fisher's Find & Replace
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Ultra Edit would do that, but it won't give you anything other then the fact that it's there.

Ultra Edit is a file editing utility, so you would not be opening these as Access DB's, just as files.

I'm sure there's other editors out there that will search through files in a directory or files that are opened.

Ultra Edit is not free, but reasonable for what it offers.

Note that it won't work if the DB's are encrypted.

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Also, if these are MDE's, it won't find a fragement of code.  MDE's don't contain source.

Jim.
0
 
mlagrangeAuthor Commented:
Thanks, Jim
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now