Executing SQL commands in ACCESS 2003

M

MasterBuilder

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
 
D

david epsom dot com dot au

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)
 
Top