r/MSAccess • u/steven4297 • 3h ago
[UNSOLVED] Can't paste into NEW SQL queries in Access 2016
Weird one. Starting today, I can't paste into the SQL editor when creating a brand new query in Access.
Steps:
- Create > Query Design
- Close the Show Table dialog
- Switch to SQL View
- Ctrl+V, right-click paste, and drag-and-drop all fail (shows the 🚫 cursor)
I can still type SQL manually and run it just fine.
Even stranger, if I manually type a query, save it, close it, and then reopen it, I'm able to paste into it normally. The problem only happens with fresh/new SQL queries.
Clipboard works everywhere else in Windows and Access is fully up to date (Office Professional Plus 2019 / Access 2016, Version 2606).
Has anyone run into this before or know what might cause new SQL queries to reject paste operations?
Weird issue that just started today.
When I create a brand new SQL query:
- Create > SQL Query
- The "Show Table" dialog pops up and I click Close.
- I try to paste some SQL text.
Nothing gets pasted. My mouse cursor briefly shows the blue spinning circle for about a millisecond and then nothing happens. If I spam Ctrl + V, eventually I get an error saying:
What's strange is that I can still type SQL manually and run it without any problems.
If I manually type a query, save it, close it, and then reopen it, I'm able to paste into it normally. The issue only happens when creating a fresh/new SQL query.
Clipboard works everywhere else in Windows 11, and Access is fully up to date (Office Professional Plus 2019 / Access 2016, Version 2606).
Has anyone seen this before or know what could cause new SQL queries to reject paste operations?