While I was trying to set up a table I had forgotten to set the identity to my key field. After I had saved it I went back and tried to set the identity but then it wouldn't let me save it without getting an error to drop the table first. After searching I found a post that brought about the solution.
There is a flag in the Tools menu. Go to Tools/Options/Designers and there will be a checkbox entitled "Prevent saving changes that require table re-creation" that you will need to uncheck. This will allow you to move ahead afterward.
Thanks to the following link for helping out.
No comments:
Post a Comment