Update Query Question

  • Thread starter Thread starter Wendy L
  • Start date Start date
W

Wendy L

Windows XP, Office XP

Can you use an update query to change the field size of a Field in a table?
For Example, if I want to change a field size of a text field in my table
from 9 to 11 characters long.

~Wendy
 
An update query cannot change the underlying structure of the table.

The easiest way to change the field size is through the GUI. Open the table
in Design mode, and change the field.

If you need to do it programmatically, you can use the ALTER TABLE syntax,
or you can add a new column, run an update query to populate the new column
from the old one then delete the old column.
 
Not an Update Query since Update Queries only updates the data, not the
Table Structure.

You need to use data-definition SQL syntax ALTER TABLE. Check JET SQL
Reference section in Access Help.
 
Back
Top