Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2009
    Posts
    2

    Unanswered: The search key was not found in any record

    This error (apparently runtime error #3709) is received when trying to import a table using the following vba command:

    DoCmd.TransferDatabase acImport, "Microsoft Access", "G:\FedBE.mdb", acTable, "Person", "Person"

    The user is running Windows Vista 6.0 with Service Pack 1 and Access 2007.

    Other local users running the same procedure using Access 2003 do not experience the problem.

    I have not been able to detect any corrupt records in the Person table.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    When apps run fine on one machine and not on another or run fine in one version and not when run under a newer version, the first thing you have to think about are missing references.

    If you haven't looked at this, here are Doug Steele's detailed instructions on how to troubleshoot the problem:

    Access Reference Problems

    I've also seen reports of this exact problem when one or more field names had leading spaces. Removing the leading spaces reportedly resolved the problem.

    As always, having all service packs and hotfixes installed seldom hurts.

    Linq ;0)>
    Last edited by Missinglinq; 12-27-10 at 22:33.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Another option that comes to my mind is Vista with its additional security. This might be a permissions thing. On that machine are you able to open the database on the G: drive? Can you import the Person table using the Access wizard to do the transfer?

  4. #4
    Join Date
    Aug 2009
    Posts
    2

    Re: The search key was not found in any record

    Thanks for your suggestions Missinglinq and DCKunkle. None of the fields in the table have leading spaces in their names, and this is just one table out of many that are being imported -- the rest work fine. I have checked the References and there don't appear to be any missing.

    However, when I tried to import the table "by hand", I got the following error message: "Reserved error -1524 there is no message for this error". Looking in the error log table that was created, the detail said "Could not open this object."

    Any ideas?

Tags for this Thread

Posting Permissions

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