|
RunSQL Action
You can use the RunSQL action to run
a Microsoft Access Action query by using the corresponding
SQL statement. You can also run a
Data-Definition query.
The RunSQL action has the
following arguments.
| Action argument |
Description |
| SQL Statement |
The SQL statement
for the action query or data-definition query you want to run.
The maximum length of this statement is 255 characters. This is
a required argument. |
| Use Transaction |
Select
Yes to include this query in a transaction. Select
No if you don't want to use a transaction. The
default is Yes. Prior to Access 97, Access
always included the query in a transaction when you ran this
action by starting with a
BeginTrans method,
executing the SQL statement, and then concluding with a
CommitTrans method. If you select
No for this argument, the query may run
faster. |
Remarks:
You can use action queries to append, delete, and update records and to
save a query's result set as a new table. You can use data-definition
queries to create, alter, and delete tables, and to create and delete
indexes. With the RunSQL action, you can perform these operations
directly from a macro without having to use stored queries.
If you need to type an SQL statement
longer than 255 characters, use the RunSQL method of
the DoCmd object in Visual Basic instead. You can type
SQL statements of up to 32,768 characters in Visual Basic.
Access queries are actually SQL
statements that are created when you design a query by using the design
grid in the Query window. The following table shows the Access action
queries and data-definition queries and their corresponding SQL
statements. You can also use an IN clause with these statements to
modify data in another database.
Note To run a Select query,
Crosstab query, Action query and SQL-Specific queries from a macro, use
OpenQuery action
to open an existing Select query or Crosstab query in Datasheet view.
| Query type |
SQL statement |
|
Append |
INSERT INTO |
|
Delete |
DELETE |
|
Make-table |
SELECT...INTO |
|
Update |
UPDATE |
|
Data-definition (SQL-specific) |
|
|
Create a table |
CREATE TABLE |
|
Alter a table |
ALTER TABLE |
|
Delete a table |
DROP TABLE |
|
Create an index |
CREATE INDEX |
|
Delete an index |
DROP INDEX |
|