Results 1 to 4 of 4
  1. #1
    EHittner is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    32

    Exclamation 3709 Error -- HELP!!

    HELP!!



    I'm developing an Access 2007 database interface and I've logged several hours on this one. When I attempt to open it, it's giving me the following error:

    "The search key was not found in any record."

    When specifying the error, the database gives me a 3709 error stating the following:

    "This error occurs when an ISAM SEEK is being executed and there are no matching values in the index."

    From there it won't let me access my database.

    What can I do to get my database back??!!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Try *importing* your db into a fresh, new db: http://www.btabdevelopment.com/ts/impnew

  3. #3
    EHittner is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    32

    New DB Doesn't Work

    When attempting to open the database -- or when attempting to import the database items to a new database, the following message comes up:

    "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."

    I could do this if it would permit me to open the database. But after agreeing to the prompt (OKing out) it just opens Access to a default application window -- not my database. Any ideas?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Maybe something on this link will be helpful: http://allenbrowne.com/ser-47.html

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 09-28-2011, 09:20 PM
  2. Error 2501 displays with Error handling
    By agent- in forum Programming
    Replies: 13
    Last Post: 08-05-2011, 02:20 PM
  3. Run-Time error '3709'
    By jscriptor09 in forum Access
    Replies: 2
    Last Post: 07-03-2011, 12:29 PM
  4. Error 13 Type Mismatch error
    By GlennBurg in forum Programming
    Replies: 1
    Last Post: 06-21-2011, 03:05 AM
  5. Replies: 8
    Last Post: 05-16-2011, 06:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums