Access crashes when mouse pointer enters specific criteria field cell

Wayne Gunn 1 Reputation point
2024-04-13T02:19:08.58+00:00

I've got a database with a number of similar group by queries, each using the Format function on a date field. Just by getting the mouse pointer in the criteria row of that particular field in design view, the database crashes, consistently, without fail.

I have tried Compact/Repair, Decompile/Recompile, repair the installation, and made certain there are no broken references in the VBIDE, all to no avail.

Does anyone here have any idea why this might be happening?

Thank you

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
822 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Karl Donaubauer 1,646 Reputation points MVP
    2024-04-15T11:27:05.8133333+00:00

    Hi,

    It could be a corruption of the query objects stored in Access. 3 things you can try:

    1. Go to SQL view of the query and copy the SQL text into a new query. Does that new query work?
    2. Create a new accdb and import all objects from the old database. There may be some warnings or errors when you try to import corrupt objects. Do the queries work in the new database?
    3. You can export the queries using VBA like this:
      Application.SaveAsText acQuery, "YourQueryName", "c:\YourQueryName.txt"
      and import it back again:
      Application.LoadFromText acQuery, "YourQueryName", "c:\YourQueryName.txt"

    If all this doesn't help then it becomes really interesting, ;-) because it might be an Access bug. There's currently another bug in queries that crashes Access. To determine whether you have a different variant, we would need to know more details, e.g. the SQL statement of your query. It would be best if you made a small sample database with only the absolutely necessary objects and test data available for download somewhere so that we can reproduce the problem.

    Servus
    Karl

    Access DevCon - online conference April 18+19
    Access Forever
    Access News
    Access-Entwickler-Konferenz AEK

    0 comments