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

  • Thread starter Thread starter CDM
  • Start date Start date
C

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?
 
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
 
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.
 
Back
Top