locked
Access very slow on Win 7 64bit RRS feed

  • Question

  • Hi

    My Access app is running very slow on Win 7 Pro 64bit compared to Win xp 32bit. I have tried the following without luck;

    1. Disabled SMB by running below;

    sc config lanmanworkstation depend= bowser/mrxsmb10/nsi
    sc config mrxsmb20 start= disabled

    2. Set MaxBufferSize to 50000 for JET entries in registry.

    3. Disabled IPV6 on network card.

    4. Set Win xp SP3 compatibility for MSACESS.EXE.

    What more can I do to fix the issue?

    Thanks

    Regards


    • Edited by Y a h y a Tuesday, June 19, 2012 2:13 AM
    Sunday, June 17, 2012 9:31 PM

Answers

  • I'm afraid there's compatibility issues for Access 2000 on Windows 7, see this information. I think you may consider a migration to Access 2010.

    thanks,


    Forrest Guo | MSDN Community Support | Feedback to manager

    • Proposed as answer by Forrest Guo Monday, July 2, 2012 3:22 AM
    • Marked as answer by Forrest Guo Wednesday, July 4, 2012 2:33 AM
    Wednesday, June 20, 2012 9:30 AM

All replies

  • Hi Yahya,

    Performance issue is hard to be addressed on forum. Do you have data shows how slow the application is?

    There're a few areas in Access application may be optimized, like forms and report, VBA and DAO. You can refer to below article for ideas:

    http://technet.microsoft.com/en-us/library/cc767939.aspx

    The article is specific Access 97, but most ideas should be valid.

    In addition, you may try running Process Monitor while running Access application. It will get you a report which thread/dll is consuming CPU/RAM.

    thanks,


    Forrest Guo | MSDN Community Support | Feedback to manager

    Tuesday, June 19, 2012 2:29 AM
  • Hi

    The same app is fast enough on winxp/32 bit so I think the issue is win7/64 bit specific.

    Thanks

    Regards

    Tuesday, June 19, 2012 4:15 AM
  • Well, Yahya.....

    Can't help much from me.

    What about Access? Your Version and is it 32-bit or 64 bit Access?

    Tuesday, June 19, 2012 4:22 AM
  • Hi

    Access 2000, 32 bit.

    Thanks

    Regards

    Tuesday, June 19, 2012 5:00 AM
  • Yahya,

    Unfortunately, MS recommends Windows 7 32-bit and Office 32-bit.

    I have Windows 7 32-bit with Access 2000, and it's working normally.

    I can't say that Access 2000 will work with Win7 64-bit, someone from MS might have a clue for this.

    The possible reason is that Access 2000 is outdated due to the fact that the System32 folder in Windows 7. The files inside might be 64-bit instead of 32-bit. Due to this, Access 2000 is reading System32 instead of WowSystem64 (spell check, need to verify).

    If it's not the problem, it could be a problem of hardware issues. I just had a problem with a network switch which was faulty. It was causing a slow down for Access and was causing write conflict. But I guess it is very unlikely in your case.

    Tuesday, June 19, 2012 5:17 AM
  • I'm afraid there's compatibility issues for Access 2000 on Windows 7, see this information. I think you may consider a migration to Access 2010.

    thanks,


    Forrest Guo | MSDN Community Support | Feedback to manager

    • Proposed as answer by Forrest Guo Monday, July 2, 2012 3:22 AM
    • Marked as answer by Forrest Guo Wednesday, July 4, 2012 2:33 AM
    Wednesday, June 20, 2012 9:30 AM
  • I think I found out the reason : "Keyboard Language" property of the field should be set to "System".

    This is what I tried, and "YES" the speed is just fine!

    Please spread the word, I have been chasing this for almost a "Year"now!

    Good luck
    Sunday, October 6, 2013 6:33 AM
  • Hello Mahmoud,

    Where did you change the value for "Keyboard Language"

    Thanks Gerard

    Thursday, October 17, 2013 10:44 AM
  • I think this may be a trick to screw you over.

    Once you set the keyboard language to system you are not able to read anything.

    Wednesday, December 4, 2013 4:32 PM
  • I think this may be a trick to screw you over.

    Once you set the keyboard language to system you are not able to read anything.

    I don't think the poster is trying to play a trick. Text boxes on a form have a Keyboard Language property that defaults to "System". It might be different for languages other than English.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Wednesday, December 4, 2013 5:22 PM