We have some business users here who love love love their Access databases. They use them to conncet to a SQL server.
One particular unit has put together tons of little DBs with macros to automate e-mails and other tasks. The problem is that these guys hard-coded a SQL user name and password into these macros, and then one of the morons in the department accidentally e-mailed out the username and password. Can you say “security risk?” Anyhow, sine they are going to have to edit all the code anyhow, I told them to stop using SQL Auth and instead use NT credentials, but that’s another story. What I am wondering is if you know of a tool that would allow a find and replace in the macro/module section of MS Access that will work from outside of the DB (in other words, I can find it easy if I have a known DB open, what I want to do is identify a DB that contains the offending string and replace it without having to individually open and search for it).
Any ideas you have are appreciated.