Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2002
    Posts
    87

    Unanswered: Trouble inserting into a table...

    Hey everyone...
    I've got a little problem inserting values into a talble.
    I've tried:
    direct SQL (Query Analyzer)
    MS Access table editing
    openrecordset -> addnew (vb)
    runsql "INSERT INTO (vb)

    all of them timed out...

    Is it possible that somehow this table gets locked?
    I'm not using any triggers or similar things to edit & lock the table while editing it.

    I've got the same table in another db and there it works fine (even has more records in it).

    Any ideas?

    Thanks!

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Could be locked.
    Do the insert in query analyser then in another window

    select * from master..sysprocesses
    and see if anything is blocked.
    You can see what the blocking spid is doing by
    dbcc inputbuffer (spid).

    sp_who / sp_who2 may give more info.



    If this isn't the case then run dbcc checkdb on the database.

  3. #3
    Join Date
    Jul 2002
    Posts
    87

    got an image

    hi nigelrivett...
    first - thanks for the reply!
    i've made such a query when it was locked - now I don't seem to find out in wich field to look if a table is blocked by a process...
    only thing with 'lock' in it is 'lock monitor' - but I think that's an SQL proc or something like that - correct?

    Thanks for helpin'!

  4. #4
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    coroner, use sp_who2 and look for a column tittled "BlkBy". A number in this column represents the SPID of the blocking process.
    Paul Young
    (Knowledge is power! Get some!)

  5. #5
    Join Date
    Jul 2002
    Posts
    87
    Hello Paul,
    Thanks for the reply - I've found the process locking the table.
    Only problem is - it seems a normal ms-access connection (opening this table) - but I cannot understand why it's locked - I've got all my access forms and functions set to dynaset or snapshot....

Posting Permissions

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