Access 2003 gives error message "search key not found Run time Error 3709" on update query for one of the tables in the database. Repair and condense tool will allow the query to run properly. Is there a remedy for this besides continually rerunning the repair and condense tool. Table has about 10,000 records and 20 different fields. Will deleting half the table solve this problem? Manual deletion of data from the table gives the same error message until repair condense tool is utilized.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.