Query SQL View is Blank - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Query SQL View is Blank

Paul Kiener

22 hours ago

I have just noticed that whenever I enter Query design for any of my queries, SQL View is blank. Design View displays correctly and Datasheet View displays correctly. If I "Run" the Query, it runs correctly (same as the Datasheet View). This seems to be happening in most of my personal databases (I've only checked 5 or so).
I am running Microsoft 365, Access Version 2608 (Build 20326.20144)
Any suggestions as to how to get SQL View back for my databases? Thank you in advance.
Paul

Donald Blackwell @Reply

21 hours ago

Have you tried the usual troubleshooting steps - Completely exit out of Access making sure that no instances are still running (i.e. check TaskManager to make sure there's not a copy hanging in memory). Then reopen the database and see if it's there. After that, try rebooting the machine and see if it's available.

Beyond that, which SQL editor is in use on your machine, i.e. - traditional Access SQL Editor or the new Monaco Editor.

None of my machines are experiencing anything with the Monaco Editor.

	Paul Kiener OP @Reply 21 hours ago
Donald, with a red face, I have to admit that I completely forgot the obvious: Reboot! That seems to have fixed my missing SQL View. Thank you!

	Donald Blackwell @Reply 21 hours ago
Lol, been there and done that more times than I care to admit ;)

Next Unseen