Share via

Unable to run a query in Access

Anonymous
2015-10-21T22:10:23+00:00

Up until today I could execute saved queries by double-clicking them or opening them and clicking the Run button. All of a sudden I am no longer able to run saved queries at all. When double-click or clicking Run button I get no error message, but no query runs.

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

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-10-22T12:27:23+00:00

    Unfortunately, the problem is with Access on my box. Another person can open the database and run the queries on their machine, but not mine.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2015-10-22T14:54:29+00:00

    Hmm, okay let's check the References and make sure none are missing...

    http://www.access-diva.com/d5.html

    0 comments
  3. Anonymous
    2015-10-22T14:29:01+00:00

    Unfortunately working on a tightly controlled business network. Users cannot run anything as admin. Thanks for the ideas!

    0 comments
  4. Anonymous
    2015-10-22T14:15:19+00:00

    Have you tried the *Run as Admin*?  You can right mouse msaccess.exe and run as admin then open your database from within Access.  See if it let's you run the queries then.

    0 comments
  5. Anonymous
    2015-10-21T23:13:38+00:00

    Make a copy of the file then Compact & Repair and try again.

    0 comments