We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience. Learn more >
SQL Datasource will Allow Access to create insert, update, Delete Statements, SQL Server will not.[Answered]
2 replies
Last post Oct 30, 2014 03:43 PM by thagr8one78
Member
7 Points
53 Posts
SQL Datasource will Allow Access to create insert, update, Delete Statements, SQL Server will not...
Oct 30, 2014 02:20 PM|thagr8one78|LINK
Hey guys,
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?
Thanks!
All-Star
48660 Points
18169 Posts
Re: SQL Datasource will Allow Access to create insert, update, Delete Statements, SQL Server will...
Oct 30, 2014 02:26 PM|PatriceSc|LINK
Hi,
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).
Member
7 Points
53 Posts
Re: SQL Datasource will Allow Access to create insert, update, Delete Statements, SQL Server will...
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!