Share via

Access Query Debug Window

Anonymous
2010-10-13T16:21:32+00:00

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/

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-10-13T23:54:08+00:00

    Thanks for clarifying that Graham.  Only one thing to add, if the query was saved from the SQL view window, the right click popup Design View option should go straight to the SQL view window.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2010-10-13T22:56:01+00:00

    Just to round out this question, here's the procedure in Access 2007:

    1. If you don't have a query to select, create one by selectingQuery Design from the Create tab.
    2. If you do have a query you want to edit, right-click the query name in the navigation pane, and selectDesign View.
    3. Either way, by now you'll be in the query designer.
    4. On the Design tab, click the small down arrow on the bottom edge of theView button in the Results group, and select SQL. This is the SQL design surface.

    "Marshall Barton [MVP]" wrote in message news:*** Email address is removed for privacy *** .com...

    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.

    Regards, Graham R Seach Sydney, Australia

    Was this answer helpful?

    0 comments
  3. Anonymous
    2010-10-13T18:22:52+00:00

    My memory of the A2007 Ribbon is kind of foggy, but I think you have to select a query, not a table, before the ribbon shows things you can do with a query.  Either use Create to create a new query or right click an existing query in the Object Pane and select Design in the pop up menu.  Then the View menu has the SQL option.

    Was this answer helpful?

    0 comments