Occasionally my MS Access reports: The search key was not found in any record After this happens the solution is to close Access, compact and repair the backend and then delete the record. What causes this and how can I avoid it?
Whether this answer is universally true or not, I don’t know, but I solved this by altering my query slightly. Rather than joining a select query to a table and processing it, I changed the select query to create a temporary table. I then used that temporary table to the real table and it all … Read more
I just took over access website and I am trying to figure out why when i try to update a record in one table, it provides me with this message. “Microsoft JET Database Engine error ‘80040e21’ How do I find out what the related record is. Thanks for any assistance