I check and all of you are correct. The data is preserved after the re-creation. Funny, none of the documentation I found attempt to clarify that point. The statement on the checkbox led me to beleive it would not preserve the data.
>No, data is copied into modified table.
>
>>Thanks, but if I have data, doesn't this (when un-checked) dump the data when the table is re-created?
>>
>>>Greg,
>>>
>>>You may just need to go to Tools | options | expand "Designers" and click on "Table and Database Designers" and then on the right un-check "Prevent Saving changes that require table re-creation"
>>>Tim
>>>
Greg Reichert