r/MSAccess 3h ago

[UNSOLVED] Can't paste into NEW SQL queries in Access 2016

2 Upvotes

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?