locked
SQL Datasource will Allow Access to create insert, update, Delete Statements, SQL Server will not. RRS feed

  • Question

  • User515264000 posted

    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! 

    Thursday, October 30, 2014 2:20 PM

Answers

  • User753101303 posted

    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).

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, October 30, 2014 2:26 PM

All replies

  • User753101303 posted

    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).

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, October 30, 2014 2:26 PM
  • User515264000 posted

    That was it!! I made the PK increments, but forgot to turn it into a Primary Key. 

    Thanks a Bunch!

    Thursday, October 30, 2014 3:43 PM