Nov 17 2022 10:01 PM
Nov 17 2022 10:01 PM
Windows 11 Office 365 Access
Suddenly, when I copied a record in the database Access froze as if it didn't have enough memory. I tried compact and repair, repairing Office, uninstalling and reinstalling Office 365, exporting the database into CSV and importing back as text into a new table in a clean database, after that didn't work, I reduced the number of entries by 80% and imported as text into a fresh table. It still froze as soon as I control-C for 45 to 50 seconds each time.
A completely different Access database is experiencing a shorter delay after each control-C
Has anyone encountered this error or know a reputable contractor who specializes in such file specific issues?
Nov 18 2022 07:41 AM
@Art_Menius Yes I've had exactly the same problem over the past several weeks. I copy a row, then when I try to paste it, it freezes. When I copy from an Access query and paste it into Excel, the copy-paste is very very slow, much slower than it used to be.
Nov 18 2022 08:58 AM
Nov 18 2022 03:24 PM
Nov 18 2022 03:27 PM
Nov 18 2022 06:09 PM
Nov 18 2022 06:13 PM
Nov 18 2022 06:47 PM
Nov 18 2022 06:51 PM
Nov 19 2022 05:35 AM
I too have this same problem of copying a record row from table and it freezes for long time.
My database is an Access .accdb, with 14,940 records and it doesn't completely freeze, but it freezes for a few minutes. During the freeze, I've noticed that the open Access process grows in memory from around 40,000KB to around 400,000 KB before it stops growing and returns to operability.
I also have some workstations that access this same database and they are using Access 2016 without this problem. So, it seems as though Access 2019 has a specific problem that recently occurred, probably around October 15+.
I will be watching this if any further info is needed.
Nov 19 2022 05:52 AM
@George Hepworth Hi sorry, I didn't see these posts until now. I'm using a local Access database, Office 365, default database format, local tables in the database, nothing SQL linked. I'm copying and pasting in a query that is simply a listing of the table with sort on a date field. The table has one auto-number field (not the Access default index field). The table has approx 30,000 records, *but* in my attempts to narrow down the issue, I had created a fresh database and created a table, and had the same issue with much smaller fresh tables, e.g. 10 to 20 rows. For some new tables I didn't have the problem, others I did, and I thought that it might be because of a certain field type, e.g. date, but I haven't narrowed it down from there. The issue seems to have started after I had a Windows 11 update, but I can't be sure that it wasn't just coincidence. (However my inclination is that the Windows update started it.) The primary symptom is that if I pick a row and copy it Ctrl-C, then go to the new row line and selected it and paste, Ctrl-V, it freezes hard. Same with multiple rows. Another symptom is that there are queries I can copy and then paste into Access (I know about links from Excel to Access but that technique isn't effective with ever-growing queries), but the paste operation is extremely slow, e.g. 5 to 10 seconds to paste 1000 rows from an Access query to Excel.
Nov 19 2022 08:32 AM
Nov 19 2022 08:41 AM
Nov 19 2022 08:53 AM
Nov 20 2022 07:31 AM
I have Experienced the same issue. and I immediately Uninstalled the Recent Windows Update: Cumulative Update for Windows 11 Version 22H2 for x64-based Systems (KB5019980). which Resolved the Issue. Reproduced the Issues several times by Installing and Uninstalling the very Update.@Art_Menius
Nov 20 2022 08:22 AM