>>Alter Table would probably best solution. If you can use the Command window simulator in your apps, then you use the table exclusively and do a modify structure. If the table is part of a DBC, then you need to open the database exclusively first. Also the original table would need to be modified itself to prevent losing any persistent relationships, primary keys, long names, etc.
>
>I like the using the command window in my app the best. How do I get it to come up from my app?
>
>Thanks,
The simplified 'command window' is form with textbox and button. Button click event fire code:
Local cCommand
cCommand=Thisform.txtCommand.value && you type literal command in textbox
&cCommand.
Edward Pikman
Independent Consultant