Where do I type the SQL commands?

[OhioSteve]

The gui is fine but sometimes I want to type raw sql or ddl. In Oracle and sql server that is the norm. How do I get an sql prompt for my MS Access .mdb???

 

[SkipVought]

Hi,

Design a query - open the SQL in Design mode.

Skip,

_{[red]Be Advised![/red]
Alcohol and Calculus do not mix!
If you DRINK, don't DERIVE!}

 

[rubbernilly]

Should be on the left-most button (which is a drop down button). Depending on the version of access and the query type, you should at least have Design, Datasheet, and SQL.

 

[OhioSteve]

What about DDL? I want to write create table statements and set foreign keys using a pure command-line interface.

 

[PHV]

The query window, even in the SQL view pane, allow only ONE statement at a time.
You may consider playing with the DoCmd.RunSQL method in VBE.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[123FakeSt]

You could create your own sub to do this in no time.

This is a very primitive version...

Sub MySQLBox()
On Error Goto ViewError
Dim strSQL as String
Do until strSQL = "q"
    strSQL = inputbox("Enter the SQL to execute. q to Quit","SQL")

    DoCmd.RunSQL strSQL
Loop
ProcExit:
    Exit Sub
ViewErr:
    Msgbox Err.Description
    Resume Next
End Sub

The early bird gets the worm, but the second mouse gets the cheese.