Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2006
    Posts
    2

    Unhappy Unanswered: Do Not Show Any Error

    I have a really strange problem in a Access Project (SQL Database) all work fine, but in some computers (not all) do not show any error when there is a data problem like a primary key violation. don’t accept the record but don’t show the error.
    This happen in any place, even when you open a table and insert a duplicate key record. All of this made me think that is something in the configuration of the MDAC or something like that.


    Thank you

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    vould be
    its more likely to be that someone has set warnings off
    look at toptions tab
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    or you are using
    docmd.setwarnings false
    docmd.runsql strSQL
    docmd.setwarnings true

    and the troublesome users have some sort of error in one or more
    docmd.runsql strSQL
    ...leaving setwarnings OFF

    the setwarnings/runsql construct is
    a/slow
    b/inherently dangerous

    consider replacing:
    docmd.setwarnings false
    docmd.runsql strSQL
    docmd.setwarnings true

    with:
    currentdb.execute strSQL
    which is
    a/faster
    b/does not interfere with setwarnings

    izy
    currently using SS 2008R2

  4. #4
    Join Date
    Apr 2006
    Posts
    2

    Red face Not Visual Code

    This happen not in a form or in any execution code, directly you open a table and insert a duplicate record and MSAccess do not show the typical error “Primary key violation” only do not accept the record.

    I have looking for something in the MSAccess options, but I do not find anything related to this problem.

    Thank you.

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    dependong on what version you are using

    Tools | Edit / Find <confirm>

    bear in mind thoise settings are uniwue to each copy of Access.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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