Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    2

    Unanswered: EXCEPTION_ACCESS_VIOLATION when I want to update

    Hi,

    I want to update a db-column with text-format.
    The order is simple: Update tblatt set textattvalue = '...' where Attid= ...

    ... stands for a text and an ID.

    I get the exception I wrote in the subject and I don't know, what I can do.
    On 3 other Databases, which I create with the same script(=they are all equal), everything works fine.

    I hope anyone has an idea.

  2. #2
    Join Date
    Aug 2002
    Location
    UK
    Posts
    87
    if the transaction is stuck in the log the table will be locked and then you are stuck! Does this still happen if you stop and re-start the sevices?

    (Of course you could always look at the table locks )

  3. #3
    Join Date
    Aug 2002
    Posts
    2
    I had restarted the Services before, but it didn't change anything. I deleted the database (only this one, because there are 2 or 3 other important dbs) and recreated it, but nothing changed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •