Share via

Runtime error 3709 - "The search key was not found in any record"

Anonymous
2022-02-10T22:45:26+00:00

Hi,

I am having trouble importing data from Excel to Access. I do not work much with Excel, but all I have done to automate the import from Excel to Access to save the import steps in Access and I have added a command button that calls up the saved import steps.

No intricate coding, nothing fancy.

The data itself is not complicated -- very straightforward. The data comes from a Smartsheet that is exported to Excel, and then imported to Access to perform other operations.

As designed, the export-and-import process just described is going to be performed at least once a day.

As designed, the imported data is supposed to overwrite the lone table that is in the database.

The database is used merely to sift the imported data for overlapping entries. That part works well.

Not every time, but more times than I want, I get the error message noted when I try to import the Excel data. The possible reasons (and fixes) for this error that I have read about online are super vague, or they do not seem to have much to do with my situation.

What I do not understand is that if I get the 3709 error, and then go back to square one (importing the Excel data manually using "New Data Source > Import file > Excel, etc., etc."), I can pop in the very same Excel file without getting any error at all.

What seems to be going on here, and how can I get rid of this error?

Thanks for your kind help.

W.R.

Microsoft 365 and Office | Access | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-02-11T10:01:16+00:00

    Hello WR_Smith_1974,

    I hope you’re doing well.

    Error 3709 Error happens when it produces the wrong output, despite the user providing the correct input.

    You can use the Microsoft Access built-in ‘Compact and Repair’ feature for repairing a corrupt .MDB/.ACCDB database file. Please follow the below link to manually repair your corrupted database files.

    https://support.microsoft.com/en-us/office/compact-and-repair-a-database-6ee60f16-aed0-40ac-bf22-85fa9f4005b2#:~:text=Manually%20compact%20and%20repair%20a,database%20in%20the%20same%20location

    I hope this works.

    Thanks,

    SuyashThomson

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2022-02-11T05:30:10+00:00

    Dear WR,

    Welcome to the forum here.

    From your description, it seems that you encounter the "Runtime error 3709 - The search key was not found in any record" error message when you click on External Data>Excel in the Access application with a specific Excel file.

    If yes, may I know whether you can copy the data from the affected Excel file to a newly created Excel file and then import the data by using the newly created Excel file in the Access application to see the result.

    Meanwhile, I suggest you first log into the computer with the admin account>go to Control Panel>Programs>right-click on the Office applications' icon>Change>check whether there is an Online Repair option. If yes, run it and restart the computer and then do a test to see the result.

    Moreover, I'd like you click on File>Account in the Access application and upload a full screenshot of the Account page for our reference.

    Note: Remove any private information before uploading the screenshots.

    Welcome to share any updates when you have time if you need further help on this issue.

    Thanks for your effort and time.

    Cliff

    0 comments