Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Oct 2014
    Posts
    8
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Windows 10 Anniversary & Access 2010 and 2013 Issues

    Windows 10 Pro Version 1607 14393.321 64 Bit
    Pre Windows 10 OS - Windows 7 Professional 64 Bit
    Microsoft Office 2010 Pro 64 Bit
    Access 2010 Version 14.0.7173.5000 64 Bit

    I have put this in the Windows 10 Forum as the problem with both Access 2010 has only occurred on a Windows 10 PC upgraded from Windows 7 Pro and after the most recent updates from Microsoft for both Windows 10 and Office Pro.

    While Access runs databases correctly when I want to open a query in Datasheet view Access 2010 stops responding. If I leave it for an excessive time it does eventually display the Datasheet view - even simple queries on small tables.

    I have tried the troubleshooting app, reverting to default compatibility settings and also repair the Access installation. I am trying not to have to uninstall and reinstall unless that will definitely fix the issue.

    Frustratingly, a PC upgraded from Windows 8 is working fine.

    Any useful ideas?

    Thanks.

  2. #2
    5 Star Lounger petesmst's Avatar
    Join Date
    Dec 2009
    Location
    Cape Town, South Africa
    Posts
    790
    Thanks
    38
    Thanked 43 Times in 33 Posts
    Your thread title mentions Access 2013. Do you have the same problem with Access 2013? (I use Access 2013 and have not experienced any issues with Windows 10 AU, but I upgraded from Windows 8.1 -- maybe your upgrade process is the source of the problem). Perhaps using the latest AU installation ISO to do an in-place upgrade of your existing installation will sort things out?
    (My Setup: Custom built: 4.00GHz Intel Core i7-6700K CPU; MSI Z170A Gaming Carbon Motherboard (Military Class III); Win 10 Pro (64 bit)-(UEFI-booted); 16GB RAM; 512GB SAMSUNG SD850 PRO SSD; 120GB SAMSUNG 840 SSD; Seagate 2TB Barracuda SATA6G HDD; 2 X GeForceGTX 1070 8GB Graphics Card (SLI); Office 2013 Prof (32-bit); MS Project 2013 (32-bit); Acronis TI 2017 Premium, Norton Internet Security, VMWare Workstation12 Pro). WD My Book 3 1TB USB External Backup Drive). Samsung 24" Curved HD Monitor.

  3. #3
    New Lounger
    Join Date
    Oct 2014
    Posts
    8
    Thanks
    1
    Thanked 0 Times in 0 Posts
    My fault. When I started the topic I was having the same issue with 2013, but checked before posting and it appeared to be working OK so I dropped any reference in the text.

    The upgrade from Windows 8.1 has no problem it is only the upgraded Windows 7 Pro PC, which was upgraded by Microsoft updates, and only since the latest updates.

    Now both 2010 and 2013 are playing up in the same way.

    I thought I had sorted both by clearing the database cache, but that wasn't the answer. Digging further, the only way to work round the problem is to hide the Property Sheet. With Property Sheet enabled, when opening a query in Datasheet view the Property Sheet pane layout is corrupted and then Access stops responding, or sometimes responds after several minutes.

    I very much suspect that one the many updates to either Windows or Office have some bug that only affects Window 7 upgrades. I have had problems with previous updates on the Windows 7 PC and, at one stage, reverted to Windows 7 Pro and then ran all the Windows 10 upgrade and updates again.

  4. #4
    Silver Lounger lumpy95's Avatar
    Join Date
    Feb 2013
    Location
    Mojave Desert CA
    Posts
    1,845
    Thanks
    258
    Thanked 176 Times in 149 Posts
    Have you tried updating to the latest version Build 14393.351? They fixed a lot of things and if it is AU related, that may help you. If not it may be office updates.

  5. #5
    New Lounger
    Join Date
    Oct 2014
    Posts
    8
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Yes, update to 14393.351 has not changed the issue.

    Access seems to be vulnerable to Office security updates. A while back one update crippled Access until a fix was sent out.

    May have to find an Office forum then.

  6. #6
    5 Star Lounger petesmst's Avatar
    Join Date
    Dec 2009
    Location
    Cape Town, South Africa
    Posts
    790
    Thanks
    38
    Thanked 43 Times in 33 Posts
    I assume you have tried to run "repair database"?
    (My Setup: Custom built: 4.00GHz Intel Core i7-6700K CPU; MSI Z170A Gaming Carbon Motherboard (Military Class III); Win 10 Pro (64 bit)-(UEFI-booted); 16GB RAM; 512GB SAMSUNG SD850 PRO SSD; 120GB SAMSUNG 840 SSD; Seagate 2TB Barracuda SATA6G HDD; 2 X GeForceGTX 1070 8GB Graphics Card (SLI); Office 2013 Prof (32-bit); MS Project 2013 (32-bit); Acronis TI 2017 Premium, Norton Internet Security, VMWare Workstation12 Pro). WD My Book 3 1TB USB External Backup Drive). Samsung 24" Curved HD Monitor.

  7. #7
    New Lounger
    Join Date
    Oct 2014
    Posts
    8
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Sure have, and the problem affects all databases.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •