Access Query Debug Window

Question

Hi all,

I come from MSSQL background, basically if I do development I have SQL Management Studio, I can type in SQL query and execute against SQL Server. From there I see result or error messages.

Recently I need to develop a desktop application with Access 2007 as database, I need to have all SQL queries in my application. My question is that where can I find something similar, either by Microsoft or some third party tools.

Thanks

Hardy

---

Welcome to help me with my open source project at http://code.google.com/p/batch-image-watermark-processor/

Answer 1

I found a free tool at http://fishcodelib.com/Database.htm, which works perfectly!

---

Welcome to help me with my open source project at http://code.google.com/p/batch-image-watermark-processor/

Answer 2

My Access 2007 only has 4 top level menu in ribbon: Home, Create, External Data, Database Tools.

I open the table, or design the table; each action adds one more menu.

But I check each of them underneath and still don't see any item related to SQL Query or View menu.

Hardy

---

Welcome to help me with my open source project at http://code.google.com/p/batch-image-watermark-processor/

Answer 3

I don't have A2007 anymore, but the View menu has an SQL option.  It a dimb window where you can type the query's SQL statement.  Then change to datasheet view using the same menu to see the query's dataset.

You do not need a third party tool unless you want a smart SQL tool.

Answer 4

From Access 2007 table design view I don't find anywhere I can type in the sql query. Could you please point out from which menu item or toolbar button I can access the function?

Thanks

Hardy

---

Welcome to help me with my open source project at http://code.google.com/p/batch-image-watermark-processor/

Answer 5

You can run a query directly from either the Desogn View or the SQL View windows.  For Select queries just switxh to Datasheet View.  For action and DDL queries, use the Run toolbar button.