# MS Access Gurus....a little help?

**URL:** https://boards.straightdope.com/t/ms-access-gurus-a-little-help/494732
**Category:** Factual Questions
**Created:** [April 29, 2009, 2:27pm UTC](https://boards.straightdope.com/t/ms-access-gurus-a-little-help/494732 "2009-04-29T14:27:33Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![crazyjoe](https://avatars.discourse-cdn.com/v4/letter/c/f14d63/32.png) [@crazyjoe](https://boards.straightdope.com/u/crazyjoe)
#### Post date: [April 29, 2009, 2:27pm UTC](https://boards.straightdope.com/t/ms-access-gurus-a-little-help/494732/1 "2009-04-29T14:27:33Z")

</div>

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.