Evan Hoff, Professional Code Junkie

Over lunch today, I learned about one of the company's recent acquisitions. Here's the short of it:

The production system has between 6k-7k different Access databases (databases, not tables)
Since the app creates new databases on the fly, no one is sure which are production dbs

Don't ever do that. Please. And no, I couldn't make this one up even if I tried. ;-)

Published May 08 2008, 11:18 PM by hoffe

	Colin Jack said: Eek, can I ask why it creates the DB's on the fly? May 9, 2008 2:11 AM
	Dave The Ninja said: May the force be with you! May 9, 2008 5:23 AM
	Peter Ritchie said: I'm speechless. May 9, 2008 8:15 AM
	Andreas Öhlund said: Perhaps something for http://thedailywtf.com/ Repeat after me: "Access is evil and must be destroyed" "Access is evil and must be destroyed" "Access is evil and must be destroyed" "Access is evil and must be destroyed" May 9, 2008 9:31 AM
	Donn Felker said: Evan, Are you sure you dont work at the same client I working at? They are doing the EXACT same thing. Passing around MDB's like they're cookies and milk. It's a mess. May 9, 2008 11:39 AM
	Rich said: You should send this off to the DailyWTF, because it sure made me say that. May 9, 2008 11:51 AM
	Sean Chambers said: Evan, Upon acquisition, you should ask for your company issued cyanide capsule before embarking on this project. I had a similar company but it was 6k-7k "tables" and not databases. I weep for your future =) May 9, 2008 12:36 PM
	Scottw said: A sliver lining to screwed up designs is that they keep a lot of coders employed. It's not much, but you have to look on the bright side. May 14, 2008 5:19 PM
	Dad said: I laughed to high heavens when I saw this. Sorry to hear about this Son. I hope you find a way to programmattically rope all these little DBs in. August 3, 2008 9:37 PM

Name (required)

Your URL (optional)

Comments (required)

Remember Me?

Enter the numbers above:

Add