Access Query Analyzer
Jeff Key
December 16, 2002
Updated: April 25, 2007
Access Query Analyzer (and source) is now hosted on CodePlex. The rest of this page is retained for historical record. Thanks for visiting!
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.
Download (74kB)
Source (GotDotNet workspace)
