Share via

Access 365 crashes - Solution

Anonymous
2019-05-31T19:40:55+00:00

I discovered if there is multiple dlookup functions being performed on the same source query, Access will crash.  

So lets say you have a saved query (a union query).  You are building another query that not only uses fields from that source union query but additionally performs a single d-lookup on that source union query.  Access will execute the query with out any problems.  But, if you add a second d-lookup function to the query you are building, it crashes.  Access will not tell you why it failed.  It will try to recover the database via a back-up command.

If you change the query so that you are not performing a d-lookup on your source table, the bug goes away.

I have a feeling that the d-lookup function is not able to cope to performing multiple executions on the same row parameter.  In my case, I was performing a d-lookup to sum-up values of 2 different columns into the same row based on ssn.

Microsoft 365 and Office | Access | For home | 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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2019-06-02T16:07:46+00:00

    Can you create the simplest database you can think of that shows this issue, and post it in a public place like a free OneDrive account?

    Was this answer helpful?

    0 comments