The search key was not found in any record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim Niewczyk - 22 Dec 2003 15:45 GMT

I converted a database from Access 97 to XP. When I
import the same information into a XP table and then run
a query to copy the new info into a new table, I receive
the run-time error 3709, the search key was not found in
any record. The query works fine, but the
DoCmd.CopyObject bombs out trying to copy a query into a
table. The database works fine in '97. Anybody know a
solution around this problem?

Reply to this Message

rusty cranbrook - 24 Dec 2003 08:41 GMT

I've seen this too, it seems to be a fault introduced into Jet
recently by the "increasingly talented" programmers that MS has
working on Access' innards these days. Try patching Jet to the most
recent version.

> I converted a database from Access 97 to XP. When I
> import the same information into a XP table and then run
[quoted text clipped - 4 lines]
> table. The database works fine in '97. Anybody know a
> solution around this problem?

Reply to this Message

david epsom dot com dot au - 30 Dec 2003 06:30 GMT

This is a generic Jet 4.0 error message.

Your file may be corrupt (make sure Windows
is fully patched), or it may be:

301474 ACC2000: "Search Key Was Not Found in Any Record" Error
http://support.microsoft.com/?id=301474

302525 ACC2002: "Run-Time Error '3709'" Error Message When You
http://support.microsoft.com/?id=302525

(david)

Reply to this Message