Using Access to try SQL codes

[J_J]

Hi,
How can I try some SQL commans or codes with access?
Regards
J_J

 

[J_J]

Thank you Rick,
But what I actually meant was not just to "look behind the coding" of
existing querry tables,
but to try my own SQL commands on a database using Access SQL facilities...
Regards
J_J

 

[Rick Brandt]

Thank you Rick,
But what I actually meant was not just to "look behind the coding" of
existing querry tables,
but to try my own SQL commands on a database using Access SQL
facilities... Regards

If you open a query in SQL view what you see is editable and therefore you can
do exactly what you are suggesting.

 

[Randy Harris]

Hi,
How can I try some SQL commans or codes with access?
Regards
J_J

In addition to Rick's suggestion, there is an add-in, called SQL Scratchpad
that is included with the Access Developers Handbook, by Getz et al.

 

[J_J]

Can you give a d/l link for the add-in please?

In addition to Rick's suggestion, there is an add-in, called SQL
Scratchpad
that is included with the Access Developers Handbook, by Getz et al.

 

[Albert D.Kallal]

Thank you Rick,
But what I actually meant was not just to "look behind the coding" of
existing querry tables,
but to try my own SQL commands on a database using Access SQL
facilities...
Regards
J_J

I must be miss-understanding something in the above?

Just type the the sql, and hit the ! to run the sql.....

How is the above not trying your own sql commands?

You can also type sql in the debug window also, but that would be silly when
you got the query builder....

in the debug window, you can execute action queries (that don't return
records) like

currentdb.Execute "update tblCusttomers set city = 'New York' where city =
'N.Y'"

Have you actually tried the sql view of the query builder?

 

[J_J]

Thank you Albert and Rick,

I must be miss-understanding something in the above?

Just type the the sql, and hit the ! to run the sql.....

How is the above not trying your own sql commands?

You can also type sql in the debug window also, but that would be silly
when you got the query builder....

in the debug window, you can execute action queries (that don't return
records) like

currentdb.Execute "update tblCusttomers set city = 'New York' where city =
'N.Y'"

Have you actually tried the sql view of the query builder?

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.members.shaw.ca/AlbertKallal