Share via

Access Copy Paste 1 record takes forever

Anonymous
2022-11-19T04:00:09+00:00

Copy a record in a Table takes forever, around 5 minutes!!!

For several years prior Copy would take 1 nanosecond. Now after about 5 minutes I can finally Paste Append the record. Before that time I get the dreaded "Not responding" message but after several minutes that goes aways and the database works as expected until I try to copy again. Happens all the time now with COPY in this database. I have a few other databases where Copy is immediate so seems to be just this one database that is accdb created Dec 2019 3.7 MB just 1 table with 6808 records Office 2019 Access version 2210 build 15726.20202. Fields are all Short Text or number, plus 1 Date and 1 AutoNumber that is primary Key. Nothing else has a delay except for COPY. Database has a bunch of Select queries that run immediately.

Started happening after upgraded to Window 11 22H2. Maybe coincidence. Office Updates are automatic so everything up to date and unsure when last Office Update was.

Again this just started happening and I have been using Copy + Paste Append 1 record for years with no issue. If I wait long enough it works but who can wait that long really. I tried copying the database but same thing happens. One thing that does work is CUT (instead of COPY) the record then PASTE APPEND it twice so I get back the original plus can edit the duplicate but that is a bizarre workaround.

Cant think of anything else to try since Copy-Paste Append is pretty simple. I did not try an Append Query since Copy-Paste should work and is simpler for a novice like me.

Microsoft 365 and Office | Access | For business | 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

29 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. George Hepworth 22,765 Reputation points Volunteer Moderator
    2023-02-19T18:32:28+00:00

    You may be experiencing this bug, first reported last December. Read this post for background and possible workarounds until a fix is available.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-02-19T18:01:58+00:00

    Add me to that list. I have the same issue after installing Windows 11

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-11-30T18:15:54+00:00

    The issue is currently being investigated by the Windows team.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-11-23T14:29:22+00:00

    Dear Joseph,

    Based on the information Grover provided above, the Copy and Paste issue seems to have been being investigated by the related team. I suggest you use the built-in Feedback option in the Access application to report the issue to our related team as soon as possible so that they can be aware of the issue and investigate it further if you are experiencing the same issue in your environment.

    @Grover, thanks for sharing the suggestion and information here.

    Thanks for your effort and time!

    Sincerely,

    Cliff | Microsoft Community Moderator

    Was this answer helpful?

    0 comments