Change the DefinedSize property of a column

[MangroBongacello]

Hi,

I would like to change the number of characters the field in Access table can accept. Now it is set to 30, I want to set it to 200. I tried

Dim cat as new adox.catalog
dim tbl as adox.table
dim col as adox.column

set cat.ActiveConnection=MyConn
set tbl=cat.Tables("MyTable&quot
set col=tbl.Columns("MyField&quot

If col.DefinedSize=30 then col.DefinedSize=200

This gives an error: Operation is not allowed in this context.

Thank you
Mangro

 

[johnwm]

I believe that DefinedSize is read only for a column already created.

There is an example her for changing live database DefinedSize:

http://www.eside.deusto.es/grupos/g.../ADO/htm/admscdefinedsizepropertyexamplex.htm

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'