> >>>> At 10:09 14/06/2008 -0400, Keith Clark wrote: > >>>> > >>>>> How can I change the size of a field after I've created it? > >>>>> > >>> After creating a table, I cannot go back and edit a field. Base > >>> will not allow me to do that. They are all greyed out.
Barbara replied: > You don't seem to be getting a lot of answers here, maybe because others > haven't had this experience -- I've generally had no problem with making > changes, so I don't know just what you're running into here. What OOo > version and OS are you running? Is there a primary key? Is that what you > are trying to change, or something else? Anyway, one thing that should > definitely work is to create a new table with the specs you want, then > right-click the name of your current table and choose Copy. Still in the > same pane, paste (Ctrl-V works fine) to bring up the import wizard, and > fill in the name of your new table, then the option to append the data. > You proably should run through the various "Next" options to make sure > everything is as expected, then Create. This should pick up all your > data properly into the new definition. If you had some queries, forms, > or reports based on the old table, you'll need to delete or rename the > original table and give the new version the correct name. The queries > should then work fine, but the forms and reports may need > tweaking/redefinition, depending on what kinds of changes were made.. > I also tried in an SQL window: alter table "table" alter column "column" varchar(255) and all worked out. Thank you for your reply though, I appreciate all the help I can get. Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
