Thanks, that helped.

I agree that it should be the default.

I love the "my thoughts exactly" running joke!

Bill

ugh, MSFT is getting to be so frustrating. Is there any sort of end user testing going on before they release apps?

Thanks, that helped.
david, they did it on purpose i think : better for a db admin to know what he's doing before unchecking this box.

Thanks.
Now i can change in table definition thats great

Prakash Gupta

Thanks, that was the perfect answer to my problem!

Thanks It really helpfull

Regards
Shashi kant Chauhan

VERY helpful exactly our thoughts haha like ur quote and the long face.
any idea how to set the primary key as the bindingkeynavigatoritem number i actually imported the data from excel.

Thanks alot for sharing this info.

I searched alot to solve it.

Perfectly solved my problem
Thanks !

Thank you, very much.
Solved my problems !

Thank you very much, very helpful.

Thanks, It works great!

This is a confirmed bug, however, it is NOT recommended to uncheck this option as it my result in changes being lost.

http://support.microsoft.com/kb/956176

Well the date of that KB article is March 2009... this is a major problem. The whole point of a visual design tool is to use it visually... "use T-SQL instead" is not an appropriate response from Microsoft. The weird thing is it just started happening to me very recently. I was able to use the tool fine before.

Thanks, saved me lots of time. And i totally agree that it should be unchecked by default. Not sure why they designed it that way.

Thanx......

Thanks a million

MUAAAAAAAAACKS
Thanks a trillion

This has really helped me to solve the issue, lot of lot of thanks dear dear.Thanks for spending your time and share your knowledge.
Basheer

Hi Henry, Thank you so much for your very clear and comprehensive Explanation.

You must be very kind as you have prepared this answer with full screen shots.

That's really helped me and I also definitely agree that this option should be unchecked by default.

Thanx......

Thanks man! Every little bit of help (when it comes to developing a database application) is indeed welcome! You really helped us! Thank you!!

thanks.it worked.

Thanks a million

This is a risk to turning off this option. You can lose changes if you have change tracking turned on (your tables).

Chris

chrisbarba.wordpress.com/.../

Thanks for this useful article. best regards.

usefull info !! Thx

thank you

This is easy, but you have saved a lot of life with this solution. Did you act in Baywatch too?

Thank you, works great!

Thanks a lot!

Thanks, chill marooooo yar...

Thanks, chill marooooo yar...

Thanks a million dude.