Make-Table Dialog Box

Microsoft Office Access 2003

Make-Table Dialog Box

Allows you to name a table that will be created and that you will copy rows to. This dialog box appears when you change a query’s type to be a Make-Table query. You can create a Make-Table query only as part of a stored procedure.

Table Name

Type the name of the table to create. The Query Designer does not check whether the name is already in use or whether you have permission to create the table.

To create a destination table in another database, specify a fully qualified table name, including the name of the target database, the owner (if required), and the name of the table.

Note   Before you execute the query, from the Property Pages window, you can change properties of the table you want to create. For details, see Query Property Page.

See Also

Create a Make-Table Query