Access slow to open

%3CLINGO-SUB%20id%3D%22lingo-sub-1016079%22%20slang%3D%22en-US%22%3EAccess%20slow%20to%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1016079%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%204%20HP%20laptops%20-%20all%20configured%20identically%20with%20Win-10%20Home%20updated%20fully%20to%20current%201903%20plus%20all%20have%20Office%20365%20under%20a%20single%20Microsoft%20Account%20Subscription%20(so%20all%20identical).%20The%20laptops%20range%20from%202%20years%20old%20to%20brand%20new.%20The%20faulty%20one%20in%20question%20(below)%20is%2012%20months%20old.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20one%20of%20those%20laptops%20(only)%2C%20of%20the%204%20ways%20I%20know%20of%20to%20open%20a%20database%20file%2C%202%20of%20them%20take%20anywhere%20from%2030%20seconds%20to%205%20minutes.%20The%20other%202%20ways%20of%20opening%20a%20database%20file%20each%20take%201%20to%202%20seconds.%20the%204%20ways%20are%20as%20follows%3A%3C%2FP%3E%3COL%3E%3CLI%3EOpen%20Access%20and%20select%20the%20file%20by%20browsing%20or%20from%20the%20list%20of%20recent%20files%20opened%20(FAST)%3C%2FLI%3E%3CLI%3EFrom%20an%20already%20open%20Access%20database%2C%20execute%20code%20to%20open%20another%20DB%20(FAST)%3C%2FLI%3E%3CLI%3EFrom%20Windows%20Explorer%2C%20double-click%20the%20DB%20file%20(SLOW)%3C%2FLI%3E%3CLI%3ERight-Click%20the%20Access%20icon%20on%20the%20task%20bar%20and%20select%20a%20previously%20pinned%20file%20(SLOW)%3C%2FLI%3E%3C%2FOL%3E%3CP%3EIt%20seems%20to%20me%20that%20the%20first%20two%20are%20using%20MS%20Access%20to%20open%20an%20Access%20file%2C%20whilst%20the%20other%20two%20are%20using%20Windows%20to%20open%20the%20Access%20file.%20So%20I%20suspect%20that%20the%20problem%20is%20actually%20in%20Windows%2C%20not%20Access.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20only%20started%20a%20few%20weeks%20ago%2C%20so%20up%20till%20then%20on%20that%20PC%20there%20was%20no%20issue%2C%20so%20it%20looks%20like%20an%20update%20issue%2C%20but%20it%20is%20only%20affecting%20one%20of%20the%204%20laptops.%20The%20other%203%20have%20no%20trouble%20at%20all%20in%20opening%20DB%20files%20by%20any%20of%20the%204%20methods%20above.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20spent%20about%2014%20hours%20on%20the%20phone%20with%20both%20Office%20and%20Windows%20support%20staff%20(level%201%20and%202%20and%20also%20the%20S%2FW%20development%20team)%20over%20the%20last%20several%20weeks%2C%20but%20none%20of%20them%20has%20been%20able%20to%20resolve%20the%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20process%20they%20have%20completely%20reinstalled%20Office%20365%20and%20completely%20reinstalled%20Win-10.%20Neither%20action%20worked.%20They%20also%20set%20up%20a%20separate%20local%20account%20on%20the%20laptop%2C%20but%20when%20logged%20in%20under%20that%20new%20user%20name%2C%20the%20problem%20still%20existed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20support%20team%20has%20now%20given%20up%20and%20asked%20me%20to%20seek%20help%20from%20this%20community.%20I%20find%20that%20startling%2C%20to%20say%20the%20least%3A%20can't%20Microsoft%20fix%20a%20technical%20issue%20in%20one%20of%20its%20installations%3F%20That%20is%20unbelievable!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%2C%20here%20I%20am%20-%20seeking%20help.%20Does%20anyone%20have%20any%20bright%20ideas%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20reason%20it%20is%20so%20important%20for%20me%20is%20that%20I%20earn%20my%20living%20by%20designing%20and%20building%20MS%20Access%20DB%20solutions%20for%20small%20business%20people%20to%20manage%20their%20businesses.%20I%20have%20been%20doing%20that%20for%20over%2020%20years.%20And%20to%20have%20to%20wait%205%20minutes%20(instead%20of%202%20seconds)%20for%20a%20system%20to%20open%20is%20unacceptable.%20And%20sometimes%20the%20methods%20that%20work%20fast%20are%20not%20appropriate%20(like%20when%20I%20need%20to%20hold%20the%20shift%20key%20down%20as%20I%20double-click%20the%20file%20in%20the%20Windows%20Explorer%20list).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20and%2For%20suggestions%20would%20be%20most%20welcome.%20Please%20don't%20be%20concerned%20if%20I%20don't%20answer%20you%20immediately.%20I%20am%20in%20Sydney%20Australia%2C%20which%20is%20a%20different%20time%20zone%20to%20most%20of%20the%20people%20using%20this%20service%2C%20I%20would%20guess.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1016079%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1018733%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20slow%20to%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1018733%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F457198%22%20target%3D%22_blank%22%3E%40CustomMadeDB%3C%2FA%3E%26nbsp%3BAt%20first%20...%20i%20would%20go%20with%20the%20specs..no%20matter%20if%20one%20laptop%20is%2010%20years%20old%20and%20the%20other%20is%20brand%20new....an%20i7%20from%20the%20past%20would%20outperform%20some%20low%20end%20new%20processors%20and%20then%20there%20other%20things%20that%20make%20the%20difference...like%20single%20thread%20performance.%3C%2FP%3E%3CP%3EThis%20belongs%20to%20the%20CPU%20area.%3C%2FP%3E%3CP%3EMoving%20to%20memory...well%20here%20things%20are%20better%20in%20terms%20that%20newer%20rams%20are%20usually%20better...not%20dramatically%20especially%20for%20laptops%20but%20...here%20you%20want%20a%20good%20scan%20with%20MemTest%2B%20to%20ensure%20they%20are%20are%20error%20free%3C%2FP%3E%3CP%3ENow%20its%20time%20for%20the%20HDD....in%20these%20days%20if%20you%20don't%20have%20SSD%20or%20better%20M2%20you%20are%20slow...no%20matter%20what....HDTune%20should%20give%20you%20a%20first%20glimpse%20of%20what%20performance%20differences%20you%20have%3C%2FP%3E%3CP%3EOS%20....laptops%20some%20times%20have%20some%20strange%20issues%20with%20drivers..while%20they%20share%20the%20most%20with%20desktops%20tiny%20changes%20in%20firmware%20make%20the%20drivers%20a%20big%20case...check%20for%20latest%20BIOS%26nbsp%3B%20%2B%20drivers%3C%2FP%3E%3CP%3EAntivirus%20%26amp%3B%20background%20process....well%20probably%20here%20is%20the%20culprit...make%20sure%20that%20paths%20to%20Office%20are%20excluded%20and%20for%20testing%20just%20try%20to%20disable%20everything...%3C%2FP%3E%3CP%3ESince%20you%20already%20spend%2014%20hours%20i%20would%20propose%20the%20fastest%20way%20to%20check....%3C%2FP%3E%3CP%3E1st%20check%20memory%3C%2FP%3E%3CP%3E2nd%20check%20HDD%20...if%20you%20find%20that%20one%20drive%20reads%2Fwrite%20in%20the%20400-500%20Mb%20and%20the%20other%20in%2030-50Mb%2Fs%20you%20know%20that%20you%20are%20comparing%20oranges%20to%20apples.%3C%2FP%3E%3CP%3E3rd%20find%20some%20stressing%20utility%20for%20CPU%20(IntelBurn)%3C%2FP%3E%3CP%3E4th%20take%20a%20good%20backup%20of%20your%20system%3C%2FP%3E%3CP%3E5th%20...don't%20reinstall%20or%20repair%20Windows...just%20install%20fresh..clean%20the%20drive...let%20it%20update%20and%20find%20whatever%20it%20needs...don't%20install%20ANYTHING%20extra%3C%2FP%3E%3CP%3E6th%20just%20install%20Office....on%20default...preferably%2032bit%20if%20you%20are%20mixing%20development.%3C%2FP%3E%3CP%3EReport%20back%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EP.S.%20curious%20how%20you%20develop%20Access%20on%20Laptop..%20i%20have%20tried%20it%20a%20couple%20of%20time%20and%20it%20was%20a%20pain.....nothing%20beats%20a%20big%20screen%20and%20a%20wireless%20mouse%20....i%20am%20also%20a%20Ms%20Access%20developer-freelancer%20...cheers%20from%20Greece%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1018854%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20slow%20to%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1018854%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F401564%22%20target%3D%22_blank%22%3E%40tsgiannis%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20taking%20time%20to%20give%20me%20such%20a%20detailed%20response.%20One%20thing%20I%20don't%20understand%20is%2C%20if%20the%20access%20files%20can%20open%20in%201%20or%202%20seconds%20when%20opened%20from%20within%20the%20Access%20program%2C%20then%20I%20doubt%20that%20there%20is%20an%20HDD%20or%20processor%20problem.%20It%20is%20only%20when%20I%20try%20to%20open%20an%20Access%20file%20by%20double%20clicking%20it%20in%20the%20Windows%20Explorer%20list%2C%20or%20when%20selecting%20it%20from%20right-click%20on%20the%20task%20bar%20that%20it%20takes%20ages%20to%20open.%20One%20way%20takes%202%20seconds%20the%20other%20ways%20can%20take%20up%20to%202%20minutes%2C%20and%20never%20less%20than%2020%20to%2030%20seconds.%20I%20have%20a%20feeling%20it%20is%20a%20Windows%20problem%2C%20in%20which%20case%20totally%20reinstalling%20windows%20(clean)%2C%20as%20you%20suggest%2C%20is%20probably%20the%20answer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERe%20the%20laptop%20use%20for%20DB%20development%2C%20I%20have%20never%20found%20this%20to%20be%20a%20problem%2C%20as%20most%20of%20my%20clients%20use%20a%20laptop%20or%20small%20screen%20device%20some%20of%20the%20time%2C%20so%20I%20tend%20to%20format%20all%20of%20my%20systems%20for%20that%20format.%20It%20just%20means%20that%20when%20they%20use%20larger%20displays%2C%20the%20have%20a%20lot%20of%20spare%20space%20on%20the%20right.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20also%20use%20an%20attached%20display%20on%20my%20laptop%20in%20my%20office%2C%20so%20that%20helps.%20What%20sort%20of%20systems%20do%20you%20develop%3F%20Mine%20are%20all%20small-business%20related%3B%20marketing%2C%20invoicing%2C%20production%20control%2C%20purchase%20orders%2C%20etc.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1019662%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20slow%20to%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1019662%22%20slang%3D%22en-US%22%3EWell%20...%20i%20just%20tried%20to%20cover%20every%20single%20option...since%20you%20already%20have%20spend%20too%20much%20time%20without%20results%20which%20points%20to%20%22strange%22...%3CBR%20%2F%3EAs%20for%20my%20systems%20i%20develop...lets%20say%20i%20develop%20pretty%20much%20everything...%22whatever%20the%20client%20wants%22%3CBR%20%2F%3EI%20have%20a%20great%20deal%20of%20experience%20in%20enterprise%20scoped%20applications%20as%20i%20worked%20for%20many%20years%20for%20a%20big%20company%20which%20used%20Access%20as%20its%20heart%20of%20IT...a%20huge%20Access%20application%20a%20mix%20between%20ERP%20%26amp%3B%20MRP....too%20many%20years%20in%20maintaning%2Coptimizing%2Cexpanding%2C%20adding%20features%20%2C%20connections%20with%203rd%20party%20ERP....%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1018790%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20slow%20to%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1018790%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F457198%22%20target%3D%22_blank%22%3E%40CustomMadeDB%3C%2FA%3E%26nbsp%3BTo%20add%20a%20crucial%20mid%20step%20...just%20before%20step%205%20...make%20sure%20you%20stripped%20you%20Laptop%20from%20anything%20extra...USB%20drive%2Cprinters%2CNAS....%3C%2FP%3E%3CP%3EWhen%20you%20start%20step%205%20it%20will%20be%20only%20the%20Laptop%20%2Cthe%20charger%20and%20the%20USB%20stick%20with%20the%20Windows%2010%20installation%20media%20%2B%20Office%20and%20maybe%20some%20test%20LOCAL%20Access%20databases.%3C%2FP%3E%3CP%3EIt%20would%20be%20a%20good%20idea%20to%20also%20connect%20the%20laptop%20to%20the%20router%20directly%20via%20cable%20NOT%20wifi.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1063099%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20slow%20to%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1063099%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F457198%22%20target%3D%22_blank%22%3E%40CustomMadeDB%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3E%26nbsp%3BI've%20had%20a%20similar%20problem%20in%20a%20PC%20with%20Access%2FOffice%20Runtime%20installed.%20Can%20you%20check%20if%20this%20is%20the%20case%3F%3C%2FLI%3E%3CLI%3EHave%20you%20tried%20disabling%20antivirus%20%2F%20antimalware%20software%3F%20Maybe%20they%20check%20opened%20file%20via%20explorer%20but%20not%20via%20contextual%20menu%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1063544%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20slow%20to%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1063544%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F486846%22%20target%3D%22_blank%22%3E%40centomila%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20think%20it's%20the%20anti-virus%2C%20as%20I%20have%204%20laptops%20configured%20in%20identical%20manner%3A%20same%20Windows%2010%2C%20same%20Office%20365%2C%20same%20Anti-virus.%20Only%20one%20of%20the%20laptops%20has%20the%20problem%20I%20am%20describing.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1063992%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20slow%20to%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1063992%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F457198%22%20target%3D%22_blank%22%3E%40CustomMadeDB%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20all%20four%20laptops%20have%20the%20same%20Win10%20build%20and%20Access%20C2R%20version%2C%20then%20it%20must%20be%20some%20Windows%20setting%20that's%20different%2C%20e.g.%20trust%20settings.%20Are%20you%20sure%20all%20four%20laptops%20have%20the%20same%20Windows%20and%20Office%20updates%20installed%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1064035%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20slow%20to%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1064035%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F323410%22%20target%3D%22_blank%22%3E%40Frank_Rotolo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20agree%20-%20I%20think%20it%20is%20a%20Windows%20problem%20too.%20If%20I%20open%20MS%20Access%20program%20first%20and%20then%20select%20a%20database%20file%20to%20open%2C%20it%20opens%20from%20there%20immediately%20(2%20-%203%20seconds)%2C%20but%20if%20I%20try%20to%20select%20and%20open%20an%20Access%20DB%20by%20selecting%20it%20from%20the%20Right-Click%20of%20the%20Task-Bar%20Icon%20list%2C%20or%20by%20double-clicking%20the%20file%20in%20the%20Windows%20Explorer%20list%2C%20it%20take%20more%20than%2030%20seconds%20to%20open%20-%20sometimes%20up%20to%205%20minutes.%20As%20I%20understand%20it%2C%20the%20first%20two%20methods%20are%20Office%20actions%2C%20whereas%20the%20second%20two%20methods%20are%20Windows%20actions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%2C%20yes%2C%20all%204%20laptops%20are%20using%20the%20same%20version%20and%20build%20of%20Windows%20Home%20(fully%20updated)%20and%20they%20are%20all%20using%20the%20same%20version%20of%20MS%20Office%20(all%20downloaded%20from%20the%20same%20MS%20Account)%2C%20so%20they%20too%20are%20identical%20(and%20fully%20updated).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMS%20Office%20Support%20gave%20up%20on%20this%20and%20transferred%20my%20problem%20to%20MS%20Windows%20support.%20They%20quickly%20said%20it%20was%20Office%20not%20Windows%20problem%20and%20sent%20me%20back%20to%20Office%2C%20who%20sent%20me%20back%20to%20Windows%2C%20who%20then%20gave%20up%20completely%20(I%20was%20at%20Level%203%20support%20by%20then)%20and%20told%20me%20to%20ask%20my%20question%20in%20this%20community%20forum.%20So%2C%20far%2C%20no%20useful%20answers...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%20that%20in%20the%20above%20process%2C%20Office%20and%20Windows%20were%20both%20completely%20reinstalled%20and%20configured%20on%20my%20problem%20laptop%2C%20but%20the%20problem%20persisted.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1064136%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20slow%20to%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1064136%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F457198%22%20target%3D%22_blank%22%3E%40CustomMadeDB%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHmm%20okay%2C%20have%20you%20checked%20the%20windows%20file%20associations%3F%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20491px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F161592iC845636E2E07A8F4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22FileAssoc.PNG%22%20title%3D%22FileAssoc.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20502px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F161593i3214FF1C8E7AC8B9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22FileAssoc2.PNG%22%20title%3D%22FileAssoc2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1065775%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20slow%20to%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1065775%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F323410%22%20target%3D%22_blank%22%3E%40Frank_Rotolo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20-%20they%20are%20all%20associated%20correctly.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1077472%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20slow%20to%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1077472%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F457198%22%20target%3D%22_blank%22%3E%40CustomMadeDB%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENotice%20that%20your%20two%20ways%20that%20open%20fast%20is%20because%20Office%20C2R%20was%20already%20launched%20and%20active%2C%20whereas%20your%20other%20two%20are%20slow%20because%20the%20C2R%20application%20virtualization%20is%20not%20active%20(launched).%26nbsp%3B%20I%20dont%20use%20any%20C2R%20Office%20versions%20because%20they%20are%20slow%20and%20constantly%20sending%20telemetry%20to%20Microsoft%2C%20so%20I%20have%20no%20way%20of%20reproducing%20your%20issue.%20Have%20you%20tested%20your%20slow%20methods%20with%20and%20without%20internet%20connection%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1269230%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20slow%20to%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1269230%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F457198%22%20target%3D%22_blank%22%3E%40CustomMadeDB%3C%2FA%3EIt%20could%20also%20be%20there's%20a%20conflict%20in%20the%20windows%20registry%20as%20to%20which%20version%20of%20Office%2FAccess%20is%20installed%2C%20especially%20if%20you%20have%20previously%20installed%20earlier%20versions.%20In%20your%20shortcut%2C%20try%20using%20the%20full%20path%20of%20msaccess.exe%20when%20launching%20you%20application.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I have 4 HP laptops - all configured identically with Win-10 Home updated fully to current 1903 plus all have Office 365 under a single Microsoft Account Subscription (so all identical). The laptops range from 2 years old to brand new. The faulty one in question (below) is 12 months old.

 

With one of those laptops (only), of the 4 ways I know of to open a database file, 2 of them take anywhere from 30 seconds to 5 minutes. The other 2 ways of opening a database file each take 1 to 2 seconds. the 4 ways are as follows:

  1. Open Access and select the file by browsing or from the list of recent files opened (FAST)
  2. From an already open Access database, execute code to open another DB (FAST)
  3. From Windows Explorer, double-click the DB file (SLOW)
  4. Right-Click the Access icon on the task bar and select a previously pinned file (SLOW)

It seems to me that the first two are using MS Access to open an Access file, whilst the other two are using Windows to open the Access file. So I suspect that the problem is actually in Windows, not Access.

 

The problem only started a few weeks ago, so up till then on that PC there was no issue, so it looks like an update issue, but it is only affecting one of the 4 laptops. The other 3 have no trouble at all in opening DB files by any of the 4 methods above.

 

I have spent about 14 hours on the phone with both Office and Windows support staff (level 1 and 2 and also the S/W development team) over the last several weeks, but none of them has been able to resolve the issue.

 

In the process they have completely reinstalled Office 365 and completely reinstalled Win-10. Neither action worked. They also set up a separate local account on the laptop, but when logged in under that new user name, the problem still existed.

 

The support team has now given up and asked me to seek help from this community. I find that startling, to say the least: can't Microsoft fix a technical issue in one of its installations? That is unbelievable!

 

But, here I am - seeking help. Does anyone have any bright ideas? 

 

The reason it is so important for me is that I earn my living by designing and building MS Access DB solutions for small business people to manage their businesses. I have been doing that for over 20 years. And to have to wait 5 minutes (instead of 2 seconds) for a system to open is unacceptable. And sometimes the methods that work fast are not appropriate (like when I need to hold the shift key down as I double-click the file in the Windows Explorer list).

 

Any help and/or suggestions would be most welcome. Please don't be concerned if I don't answer you immediately. I am in Sydney Australia, which is a different time zone to most of the people using this service, I would guess.

 

 

12 Replies
Highlighted

@CustomMadeDB At first ... i would go with the specs..no matter if one laptop is 10 years old and the other is brand new....an i7 from the past would outperform some low end new processors and then there other things that make the difference...like single thread performance.

This belongs to the CPU area.

Moving to memory...well here things are better in terms that newer rams are usually better...not dramatically especially for laptops but ...here you want a good scan with MemTest+ to ensure they are are error free

Now its time for the HDD....in these days if you don't have SSD or better M2 you are slow...no matter what....HDTune should give you a first glimpse of what performance differences you have

OS ....laptops some times have some strange issues with drivers..while they share the most with desktops tiny changes in firmware make the drivers a big case...check for latest BIOS  + drivers

Antivirus & background process....well probably here is the culprit...make sure that paths to Office are excluded and for testing just try to disable everything...

Since you already spend 14 hours i would propose the fastest way to check....

1st check memory

2nd check HDD ...if you find that one drive reads/write in the 400-500 Mb and the other in 30-50Mb/s you know that you are comparing oranges to apples.

3rd find some stressing utility for CPU (IntelBurn)

4th take a good backup of your system

5th ...don't reinstall or repair Windows...just install fresh..clean the drive...let it update and find whatever it needs...don't install ANYTHING extra

6th just install Office....on default...preferably 32bit if you are mixing development.

Report back

 

P.S. curious how you develop Access on Laptop.. i have tried it a couple of time and it was a pain.....nothing beats a big screen and a wireless mouse ....i am also a Ms Access developer-freelancer ...cheers from Greece

Highlighted

@CustomMadeDB To add a crucial mid step ...just before step 5 ...make sure you stripped you Laptop from anything extra...USB drive,printers,NAS....

When you start step 5 it will be only the Laptop ,the charger and the USB stick with the Windows 10 installation media + Office and maybe some test LOCAL Access databases.

It would be a good idea to also connect the laptop to the router directly via cable NOT wifi.

Highlighted

@tsgiannis 

 

Thanks for taking time to give me such a detailed response. One thing I don't understand is, if the access files can open in 1 or 2 seconds when opened from within the Access program, then I doubt that there is an HDD or processor problem. It is only when I try to open an Access file by double clicking it in the Windows Explorer list, or when selecting it from right-click on the task bar that it takes ages to open. One way takes 2 seconds the other ways can take up to 2 minutes, and never less than 20 to 30 seconds. I have a feeling it is a Windows problem, in which case totally reinstalling windows (clean), as you suggest, is probably the answer.

 

Re the laptop use for DB development, I have never found this to be a problem, as most of my clients use a laptop or small screen device some of the time, so I tend to format all of my systems for that format. It just means that when they use larger displays, the have a lot of spare space on the right.

 

I do also use an attached display on my laptop in my office, so that helps. What sort of systems do you develop? Mine are all small-business related; marketing, invoicing, production control, purchase orders, etc.

Highlighted
Well ... i just tried to cover every single option...since you already have spend too much time without results which points to "strange"...
As for my systems i develop...lets say i develop pretty much everything..."whatever the client wants"
I have a great deal of experience in enterprise scoped applications as i worked for many years for a big company which used Access as its heart of IT...a huge Access application a mix between ERP & MRP....too many years in maintaning,optimizing,expanding, adding features , connections with 3rd party ERP....
Highlighted

@CustomMadeDB 

 

  •  I've had a similar problem in a PC with Access/Office Runtime installed. Can you check if this is the case?
  • Have you tried disabling antivirus / antimalware software? Maybe they check opened file via explorer but not via contextual menu
Highlighted

@centomila 

I don't think it's the anti-virus, as I have 4 laptops configured in identical manner: same Windows 10, same Office 365, same Anti-virus. Only one of the laptops has the problem I am describing.

Highlighted

@CustomMadeDB

 

If all four laptops have the same Win10 build and Access C2R version, then it must be some Windows setting that's different, e.g. trust settings. Are you sure all four laptops have the same Windows and Office updates installed?

Highlighted

@Frank_Rotolo 

I agree - I think it is a Windows problem too. If I open MS Access program first and then select a database file to open, it opens from there immediately (2 - 3 seconds), but if I try to select and open an Access DB by selecting it from the Right-Click of the Task-Bar Icon list, or by double-clicking the file in the Windows Explorer list, it take more than 30 seconds to open - sometimes up to 5 minutes. As I understand it, the first two methods are Office actions, whereas the second two methods are Windows actions.

 

And, yes, all 4 laptops are using the same version and build of Windows Home (fully updated) and they are all using the same version of MS Office (all downloaded from the same MS Account), so they too are identical (and fully updated).

 

MS Office Support gave up on this and transferred my problem to MS Windows support. They quickly said it was Office not Windows problem and sent me back to Office, who sent me back to Windows, who then gave up completely (I was at Level 3 support by then) and told me to ask my question in this community forum. So, far, no useful answers...

 

Note that in the above process, Office and Windows were both completely reinstalled and configured on my problem laptop, but the problem persisted.

 

Highlighted

@CustomMadeDB

 

Hmm okay, have you checked the windows file associations?FileAssoc.PNGFileAssoc2.PNG

Highlighted

@Frank_Rotolo 

Yes - they are all associated correctly.

Highlighted

@CustomMadeDB

 

Notice that your two ways that open fast is because Office C2R was already launched and active, whereas your other two are slow because the C2R application virtualization is not active (launched).  I dont use any C2R Office versions because they are slow and constantly sending telemetry to Microsoft, so I have no way of reproducing your issue. Have you tested your slow methods with and without internet connection? 

Highlighted

@CustomMadeDBIt could also be there's a conflict in the windows registry as to which version of Office/Access is installed, especially if you have previously installed earlier versions. In your shortcut, try using the full path of msaccess.exe when launching you application.