VB & Database, ADOX: Extending a fixed length Jet string field length

ADOX: Extending a fixed length Jet string field length

Author	Message
Lee Gilli #1 / 2	ADOX: Extending a fixed length Jet string field length Is it required to drop the column and re-add it, or can this be done by simply changing a property of the column. When I modify the DefinedSize property, it resulted in an error. I think Access can change this without changing the order position of columns. Can that be done through ADOX ? -- ______________________________________________________________________ Lee Gillie, CCP Remove NOSPAM to E-Mail Online Data Processing, Inc. - 3501 N. Haven - Spokane, WA 99207-8500
Sun, 17 Nov 2002 03:00:00 GMT

Dean Slinde #2 / 2	ADOX: Extending a fixed length Jet string field length Yes, use the Alter DDL statement. Char and Binary types can be lengthened with ADOX. The syntax is something like this: Alter TABLE (tableName) Alter COLUMN (column name) Char (50). Use Char, not WChar or VarWChar. Dean Slindee Quote: > Is it required to drop the column and re-add it, or can this be done > by simply changing a property of the column. When I modify the > DefinedSize property, it resulted in an error. I think Access can > change this without changing the order position of columns. Can that > be done through ADOX ? > -- > ______________________________________________________________________ > Lee Gillie, CCP Remove NOSPAM to E-Mail > Online Data Processing, Inc. - 3501 N. Haven - Spokane, WA 99207-8500
Fri, 22 Nov 2002 03:00:00 GMT

Page 1 of 1

[ 2 post ]