Forum Discussion
Access freezes when I copy a record
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?
- I also did that and saw the problem remained
112 Replies
- Can you be a bit more specific?
Is the data in an ACE table, or a linked SQL Server or other database table?
When you attempt to do this, are you using a form in datasheet view, in single form view, or in continuous view?
Does it also occur if you try to copy a record from the table in datasheet view?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.
- I've asked the Access team at Microsoft to investigate this and provided them with links to this and other threads reporting the same problem. It certainly looks to me like a bug as you describe it.
- It is in an Access table. I am in datasheet view
Yes, it occurs in any Access table or query with more than 1000 records
It started after the most recent update to Win 11- And only if the table contains more than 1,000 records?
How is the table sorted? What Indexes are on it? I am assuming that it would have a Primary Key, but please confirm that, as well.?
Also, please confirm whether this is a local table in the same accdb, a linked table in a second accdb, or a linked table in a different database, such as SQL Server.
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.
- Thanks. Have you been able to resolve. I have spent 3 hours with MS Business support with no progress
Art_Menius Nope, but if I get a chance I'll try to figure it out. I think it might be happened after a recent Windows 11 update.
