Searching VBA Code & Macros in 80+ databases.

[Scott]

I need to analyze VBA code and macros across 80+ MS Access databases.
Can you suggest the best way to handle this?

In case it helps, here's what I'm doing. We are moving to a new
Windows Domain and all the users at this location will be getting new
user IDs. I need to search the MS Access databases, finding where the
code/macros is pulling the current-user name. With this identified,
I'll be able to analyze whether or not the code needs to be changed to
support the new user names.

I'd appreciate suggestions on the best way to search through the code
in these 80+ databases,'

Thanks!

 

[Guest]

Here is a link to a good find and replace utility that will make it pretty
easy for you:

http://www.rickworld.com/download.html

It is the best $39.00 you will ever spend on software.

I have been using it for a couple of years and really like it.