Last post Oct 30, 2014 03:43 PM by thagr8one78
Oct 30, 2014 02:20 PM|thagr8one78|LINK
It's Been a few years since I have been on. I have a SQL Data source question. I have a SQL Data source that will allow Updating , Deleting and Inserting statements Via Access, but my SQL Server connection will not allow them.
The Data displays normally and I Can manually write an insert Statement. Can anyone tell me what I have wrong in VS 2013 that will not Allow the SQL String to create these options?
Oct 30, 2014 02:26 PM|PatriceSc|LINK
Do you have some kind of error message ? My first though would be not having a primary key on this table (but it's been a while since I used this control).
Oct 30, 2014 03:43 PM|thagr8one78|LINK
That was it!! I made the PK increments, but forgot to turn it into a Primary Key.
Thanks a Bunch!