I've started using Access, and finding it very poorly designed and badly documented.
My previous experience was on SQL Server, where you can of course view the SQL of a query and the query results at the same time. Not only does it look like you can't do this in access, but also whenever I switch between SQL view and Query view it retriggers the query. ARGGGGG!!!
In fact, I have several queries that I really really do not want to run, but really really want to view the SQL. But I can't work out how.
Can anyone enlighten me as to whether this is possible?
I'm on the verge of just ditching Access altogether in favour of SQL Server. Only thing holding me back is that Access is more widely available to my users.
My previous experience was on SQL Server, where you can of course view the SQL of a query and the query results at the same time. Not only does it look like you can't do this in access, but also whenever I switch between SQL view and Query view it retriggers the query. ARGGGGG!!!
In fact, I have several queries that I really really do not want to run, but really really want to view the SQL. But I can't work out how.
Can anyone enlighten me as to whether this is possible?
I'm on the verge of just ditching Access altogether in favour of SQL Server. Only thing holding me back is that Access is more widely available to my users.