Forum Discussion
Access does not respond when creating a query
Unfortunately, that sounds like it could be a problem with the Query Wizard in your installation of Access, or it could be a problem with available tables in the specific accdb, or it could be something else.
You didn't indicate whether this is a new problem appearing after you've worked with a specific accdb for some time, or if it's the first time you tried to create any query in any Access accdb. That makes some difference in identifying potential problems.
Let's start with a simple test. Does this happen in any accdb? Or only in one specific accdb? That would tell us, for example, if the accdb is somehow corrupted or something, or if the problem is in your installation of Access itself.
Once you've determined that, we should look at the tables. Do you HAVE tables set up? I assume so, but we like to cover all the bases.
If the problem appears to be in the Access installation, the next trouble-shooting step is to repair it, or reinstall it.
Try those things and let us know how it turns out, and also more details about the environment (new problem after working for some time or first time use of Access raising the problem).
It would not hurt to tell us the version of Access you are using as well.
There is a recently reported bug using wizards, although I don't recall specifically that it impacted the Query Wizard. It probably does as well.
It happens with tables that have an MVF or attachment field in them.
- Thanks for the response, so you're saying we have hope that someone is looking into this issue.
Thank you- Yes, as long as it turns out the problem is general to all wizards. Also, can you confirm that your accdb does have an MVF or attachment field in the table which raised the error?