Windows 10: MS Access much slower on computation with Win 10?

  1.    13 Jul 2016 #1

    MS Access much slower on computation with Win 10?


    I have a MS Access database that requires a high level of computation when making changes to the SQL structure thru imported tables etc. With Win 7 on my Dell i7 XPS 8300 this took a few minutes. Now with a clean install of Win 10 and the same Access 2010 version it takes up to 10 minutes. Task Manager doesn't show the CPU running at 100% but something has slowed down. Anyone else seen computation slow downs with Win 10 versus Win 7?
      My ComputerSystem Spec


  2. Posts : 662
    Windows 10 1703 Pro x64 (Creators Update)
       13 Jul 2016 #2

    No, I have not seen any slow downs versus 7. I think Windows 10 is faster than 7, I would check in Task Manager and see what programs are hogging up memory, disk, CPU, or anything else and close any programs you are not using at the moment. I would try those and see what happens. It could be that it is the Office 2010, it may not be optimized for Windows 10 just yet or maybe never.

    So what you're saying is, is that it is taking around 10 minutes to edit or load a database? You may have to buy Office 2013 or 2016, that might be a good route to go, so that then you are more updated to the latest things.
      My ComputersSystem Spec


  3. Posts : 1
    WIN SERVER 2012
       12 Aug 2016 #3

    DaiB said: View Post
    I have a MS Access database that requires a high level of computation when making changes to the SQL structure thru imported tables etc. With Win 7 on my Dell i7 XPS 8300 this took a few minutes. Now with a clean install of Win 10 and the same Access 2010 version it takes up to 10 minutes. Task Manager doesn't show the CPU running at 100% but something has slowed down. Anyone else seen computation slow downs with Win 10 versus Win 7?
    Sorry for my English Google Translation


    I think I have the solution.
    I was 4 days watching lots of opinions and the solution, as always, it was very simple.
    It helped me a comment on the speed of Access and links.
    It turns out that was not used as tables and links called at that time were non-existent (due to changes in computer and its local routes or network).
    With 34 bits there was no problem when you open a still good local table without linking, but with a 64-bit (in my case Windows Server 2012) to open the good board was slow to open 2 minutes, staying the hanging Access ( " no answer ").
    The problem disappears miraculously remove the tables with nonexistent links and not really useless to have them as well. Eye, removing each of these tables, the Access a minute or hangs. Must be left until you see deleted the table. So do the same with wrongly linked tables, and then restart the Access (to close for the first time also hang a little).
    And voila, that's all.
    Microsoft should notify the Access to open a link failures to proceed to remove them.
      My ComputerSystem Spec


 

Related Threads
Boot time is getting slower and slower in Performance & Maintenance
I built my latest PC and upgraded the Windows 10 Home 32 bit to 64 bit back in December. I have 32GB RAM and have an I7 processor. My boot times continue to get slower and slower the past several months. I have googled solutions and tried many...
Slower Shutdown since last 2 updates. in Performance & Maintenance
Hello ALL: I am on 64 bit Windows 10 Pro 10586.29. Before the last 2 updates, my system, with a 512GB SSD would shut down in 4 to 5 seconds. Since the last 2 updates, it has gone from a very fast 5 seconds to about 15 to 20 seconds. Is there any...
Programs load slower than windows 7 in Performance & Maintenance
So I upgraded finally after I felt that windows 10 was on the right track. I noticed my programs load 5 to 8 seconds slower than with windows 7. I have 2 ssd drives and sometimes when I am searching for a file it will tell me "WORKING ON IT". ...
Solved User accounts slower than one other in Performance & Maintenance
When I downloaded Microsoft 10, I went back on my account and after a couple of minutes the whole thing worked fine, and I didn't see any problems. But, when another family member went on their account, it was MUCH slower than mine, and they...
Slower speeds with windows 10? in Network and Sharing
Hello, My speeds before on speedtest were about 130 mbps. After just installing windows 10 I am getting a max of about 90. Any fix for this? What is the problem?
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 16:40.
Find Us