Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Angry Unanswered: JET Database Engine error

    I've seen other postings for this error, but I wanted to see if anyone had something a little more solid on how they resolved the issue. When trying to execute a dts package I'm receiving the error:

    the number of failing rows exceeds the maximum specified. (Microsoft Jet Database Engine (80004005). Could not update; currently locked. Does anyone have any suggestions? Thanks in advance!

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    yeah, you've probably have data that is corrupt...

    Can you modify so it goes in to a table with no contraints?

    Where is the file coming from (where is it going)?

    It's probably going to be dup primary key, validation rule exception, fk problem, or some other constraint....

    just a guess...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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