>>The message says "Saving changes is not permitted.The changes you have made require the following tables to be dropped and re-created. You have either made the changesto a table that' can't be re-created or enabled the option Prevent saving changes that require the table to be re-created".
>>
>>All of which is wrong. Saving changes is generally permitted, not "not permitted" in general - a qualifier is missing. "Changes... require the table to be dropped" - wrong, changing from decimal(14,1) to decimal(14,2) does not. "You have made changes to a table that can't be re-created" - I've never seen such a table. _Every_ table can be re-created, just run the create script again. "...Or you have enabled the option..." - wrong, I never touched it, it's the default of a setting I never even knew existed.
>>
>>Permission to re-blog?
>
>Ah, I see. There is a lot of labeling here.
>
>The option I was referring to is "Tools\Options\Designers\Prevent saving changes that require table re-creation". But, you are probably aware of that.
Only vaguely. The very existence of such an option, specially after discovering that it may be wrong both ways (forbidding changes which don't require re-creation, or allowing those that do), made me wonder what other pieces of bad design are in there. And the help contains negative information - each time I tried to use it I ended up knowing less than before. So, Toad.