Revision history [back]

To create a new table by changing the current table type, follow these steps:

1. Open the database management system and open the database where the existing table is stored.
2. Select the existing table and right-click on it. Choose “Design View” from the context menu.
3. In design view, right-click on any part of the table structure and select “Properties” from the context menu.
4. In the “Properties” dialog box, select the “Table” tab.
5. Choose the type of table you want to create from the “Table Type” drop-down list. You can select “Access” to create a new table in Microsoft Access, “ODBC Database” to create a table in an ODBC-compatible database, or “Linked” to link the table structure to a table in another database.
6. Once you’ve selected the table type, click “OK” to create the new table.

Note: Changing the table type will create a new table with the same structure as the old table. Any data in the old table will not be transferred to the new table.