Updating new records

Discussion in 'microsoft.public.sqlserver.programming' started by Ture Bergstrøm, Dec 11, 2007.

  1. I have migrated my Access-database to SQL-server with Access as front end
    and I am now testing it. My current problem is that whereas I can freely add
    new records to the table in question, these new records cannot be changed
    again. I get the error message "This record has been changed by another user
    after you started editing...." and the changes are not accepted.

    "Old" records from before migrating can freely be changed.

    What can be wrong??

    TureB
     
    Ture Bergstrøm, Dec 11, 2007
    #1
    1. Advertisements

  2. Sounds like you are using the Open Table feature in Mgmt Studio. I recommend
    against using it, and instead you should simply use UPDATE and INSERT
    statement that you can save and repeat.

    I don't recall the exact cirucumstances when you can get this error, but
    it may be that the table does not have a primary key.
     
    Erland Sommarskog, Dec 11, 2007
    #2
    1. Advertisements

  3. I have simply linked the tables in SQL Server using the features in Access,
    not having experience with advanced programming in SQL-S. The table has a
    primary key; this field is in Access an 'Autonumbering' field; when I look
    in the Mgmt Studio the data type is 'int'.

    Can it be a problem that the front- and back-end is on the same computer?

    TureB
     
    Ture Bergstrøm, Dec 12, 2007
    #3
  4. So are you getting this error in Access, or in Open Table in SSMS? Could you
    post the CREATE TABLE statement for the table?
    No. But obviously if you work from Access and Open Table interchangably
    you could get this error. No matter if they are on the same machine or
    different.
     
    Erland Sommarskog, Dec 12, 2007
    #4
  5. At last I managed to encircle the error after reading in a German Access
    newsgroup.

    I had a column with datatype bit, where NULLs were allowed. After changing
    this and setting False as default value the table worked properly from the
    Access front-end.

    Thanks to Erland for the help.

    TureB
     
    Ture Bergstrøm, Dec 16, 2007
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.