Microsoft Access Runtime Error 3709
Contents |
Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rate Thread Display Modes 12-11-2007, 06:12 AM #1 Alisa Registered User Join Date: Jun 2007 Location: Colorado, U.S.A. Posts: 1,931 Thanks: 0 Thanked 7 Times in 5 Posts Runtime error 3709 The search key was not found in any record I am getting this error in my import routine: Code: DoCmd.TransferDatabase acImport, "Paradox 5.x", ImportDir, , oFile.Name, Left(oFile.Name, Len(oFile.Name) - 3) Since it is happening when I am importing, the solutions previously suggested like the Microsoft kb fix won't work - I haven't even imported the table yet so https://support.microsoft.com/en-us/kb/302525 how can I delete an index or delete corrupt records? Does anyone have any ideas about fixing this? My only idea is to rewrite my routine to link instead of import, but I'm not sure that would even help. Alisa View Public Profile Find More Posts by Alisa 01-09-2008, 08:35 AM #2 ctolkamp Registered User Join Date: Jan 2008 Posts: 1 Thanks: 0 Thanked 1 Time in 1 Post I had the same message when importing an http://www.access-programmers.co.uk/forums/showthread.php?t=140284 Excel spreadsheet. The problem was that one of the field/column names in Excel started with a space. Removing the space fixed the problem. The Following User Says Thank You to ctolkamp For This Useful Post: VBA(06-07-2011) ctolkamp View Public Profile Find More Posts by ctolkamp 06-08-2009, 11:01 AM #3 Johnny Redneck Registered User Join Date: Apr 2009 Posts: 8 Thanks: 0 Thanked 0 Times in 0 Posts Re: Runtime error 3709 The search key was not found in any record A bit late I know... But I just bumped into this error in an Access 2007 application. I'm adding records via a very simple form and have no indexes at all on the table that gives the error seemingly at random when adding new records. Also, there are no memo fields or field names with spaces as have been implicated in other instances of this problem on the net. In my case, I realised when re-examining the form (which I had copied from another) that I had accidentally left the "Filter on load" property set to True with no filter specified. I switched off "Filter on load" and the error went away. Hope this helps Johnny Redneck View Public Profile Find More Posts by Johnny Redneck « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Ra
any record.-RESOLVED If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 2 of 2 Thread: The search key was not found in any record.-RESOLVED Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Jul 23rd, 2003,01:44 PM #1 bebandit View Profile View Forum Posts Visit Homepage Thread Starter Addicted Member Join Date May 2002 Posts 142 The search key was not found in any record.-RESOLVED I have an Access 2002 database and I can update and delete just fine. I made a new table called hardware. I added two fields (code and pinkgroup). I can insert into these tables but everytime I try to update one I get: The search key was not found in any record. I searched the internet and it says that it is probably a corrupted database and that I need tp use compact and repair which I did. I even deletedthe table and made them again. Every time I go to update, I get the same message. HELP...!!!!!!!! Last edited by bebandit; Jul 23rd, 2003 at 01:50 PM. Reply With Quote Jul 23rd, 2003,01:49 PM #2 bebandit View Profile View Forum Posts Visit Homepage Thread Starter Addicted Member Join Date May 2002 Posts 142 I found it!! From MSDN online . . . quote: -------------------------------------------------------------------------------- ACC2002: "Run-Time Error '3709'" Error Message When You Enter a Large Amount of Text in a Memo Field That Contains an Index The information in this article applies to: Microsoft Access 2002 This article was previously published under Q302525 Moderate: Requires basic macro, coding, and interoperability skills