Does someone have a SQL scratchpad form to test sql statements?

[CDM]

I'd like to try out sql statements before actually using them on my data. Is
there a form out there that would let you type in a SQL statement and view
the results?

 

[Clifford Bass]

Hi,

Why not just use the Access Query tool? If you want to type in the
SQL, change it to SQL View. If you are wanting to avoid doing it against a
production database so you do not interfere with active users, just use a
copy. Likewise, if you are wanting to test action queries such as update and
delete queries, again, use a copy.

Clifford Bass

 

[pietlinden]

I'd like to try out sql statements before actually using them on my data.Is
there a form out there that would let you type in a SQL statement and view
the results?

there's one in the Access <version> Developer's Handbook in the
Desktop version.