Resize a Field in an Access 2.0 Table (Error 3219)
Posted on 2001-07-18
I have a MS-Access 2.0 Database. There is a table "Customers" and a field "Description" of type text.
Now i have to resize the field from 10 to 20 characters (using vb6).
I can't execute:
because of Error 3219.
Please don't suggest:
1. Add a new field to the fields-collection with the desired properties (and a different field name, say 'NewField')
2. Copy all data from 'Description' to 'NewField'
3. Remove 'Description' from 'Customers'
4. Rename 'NewField' to 'Description'
or something like that, because i don't want to copy any data (there are a lot of records in 'customers').
Thanks in advance :-)