Executing SQL commands in ACCESS 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When to I go in MS ACCESS in order to type and execute SQL commands in MS
Access 2003 and legacy versions of Access.

Please step me through to the location for executing CREATE Tables, CREATE
Index, etc.. DDL, DML SQL commands.

Thanks
 
Open a database.

Press [ctrl][g]

For Jet DDL, type

Codedb.Execute "create ..."

For "Ansi 92" DDL, type

currentproject.Connection.execute "create ..."

(replace the ellipsis with your ddl)


(david)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query on SQL Server is fast, while Access is crawling 2
Help: SqlConnection in ReadOnly Mode 1
Linked MS SQL Server Tables 3
"insert/delete queries" <--- careless parlance ? 3
How do I execute multiple SQL statements in Access?? 3
Insert data from SQL table into Access table 3
DDL Query execution 3
SQL query 1

Back
Top