Editor: I wrote against the Jet database engine way back in the early, early VB days. I was never really hip to the query Wizard. I'm still not. I haven't written an application that uses an Access database in a long time, but occasionally need to work with data, so Access is GeneRally the quickest way to do it. I find myself using the SQL view of the Query window in Access and it's painful. I just want a way to query the thing quickly and move on. I longed for my friend Query Analyzer.
Anyway, I thought it would be quicker to write one instead of trying to find one on the internet. I was right. This thing took 45 minutes to write and that includes fifteen minutes to make the icon. Isn't .NET great?
The thing is very simple. Select a database, enter a query and press F5 or CTRL+E (or click Execute if you're into that kind of thing). View results. Rinse. Repeat.
v1.1 Changes
Selected text is queried if text is selected (like SQL Query Analyzer).
Remembers last database opened.
Can save/load sql.
Annoying beep on CTRL+E eliminated