Forum Discussion
Solved
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 reins...
- I also did that and saw the problem remained
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?
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?
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
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.- Yes. I just tested a table with 920 records. Cut and paste worked normally. 1100 record table experiences a freeze not as long as 4900. 31000 record table freezes completely.
Primary key is ID and the only permanent index. Sorted on whatever column needs for the immediate function. Fails have happened on several different sorts.
These are all local tables in their own Access accdb's - Okay, then. I can confirm that this occurs as described in a local Access table with 300,000 records at any rate. Given that I'm going to assume there is a new problem that needs to be investigated with Microsoft. I'll see if anyone has reported this yet.
Can you also please provide answers to the questions I asked?ms 365 access not responding after doing cut and paste in local tableGeorge_Hepworth
