An Access Program No Longer Responds after MS Tech Changed Registry

%3CLINGO-SUB%20id%3D%22lingo-sub-1469185%22%20slang%3D%22en-US%22%3EAn%20Access%20Program%20No%20Longer%20Responds%20after%20MS%20Tech%20Changed%20Registry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1469185%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20program%20written%20in%20Access%20that%20is%20a%20front%20end%20and%20connects%20to%20a%20back%20end%20database.%20This%20is%20an%20MDB%20file.%20The%20program%20has%20buttons%20you%20can%20click%20to%20download%20documents%20from%20the%20web.%20The%20buttons%20were%20not%20working%20but%20everything%20else%20was%20working.%20The%20Tech%20decised%20to%20make%20some%20type%20of%20change%20in%20the%20Registry%20and%20now%20none%20of%20the%20buttons%20do%20not%20respond%20and%20I%20have%20no%20idea%20what%20he%20did.%20He%20dumped%20me%20off%20here%20to%20get%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBTW%20I%20believe%20the%20problem%20I%20was%20having%20was%20related%20to%20a%20default%20app%20and%20had%20nothing%20to%20do%20with%20Access.%20I%20would%20like%20to%20strangle%20him!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated.%3C%2FP%3E%3CP%3ETIA%3CBR%20%2F%3EWalter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1469185%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1470732%22%20slang%3D%22en-US%22%3ERe%3A%20An%20Access%20Program%20No%20Longer%20Responds%20after%20MS%20Tech%20Changed%20Registry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1470732%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F701443%22%20target%3D%22_blank%22%3E%40walterwood442320%3C%2FA%3E%26nbsp%3BThat's%20an%20unfortunate%20situation.%20However%2C%20no%20one%20here%20can%20possibly%20know%20what%20changes%20were%20made%20to%20your%20registry%2C%20nor%20why%20they%20were%20made.%20It's%20especially%20unfortunate%20that%20someone%20working%20for%20Microsoft%20%22dumped%20you%20off%20here%22%20rather%20than%20taking%20responsibility%20for%20the%20action.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20can%20offer%20some%20suggestions%20about%20things%20to%20try%2C%20but%20realistically%2C%20not%20having%20any%20idea%20what%20those%20registry%20changes%20were%20makes%20it%20difficult.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20starters%2C%20can%20you%20open%20a%20VBA%20module%20and%20compile%20the%20code%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1470769%22%20slang%3D%22en-US%22%3ERe%3A%20An%20Access%20Program%20No%20Longer%20Responds%20after%20MS%20Tech%20Changed%20Registry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1470769%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F46682%22%20target%3D%22_blank%22%3E%40George%20Hepworth%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20screenshot%20of%20the%20Compile%20Action.%20Do%20this%20and%20see%20what%20errors%20are%20raised.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CompileVBA.png%22%20style%3D%22width%3A%20466px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199226i3115B271A995C6F5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22CompileVBA.png%22%20alt%3D%22CompileVBA.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20check%20the%20references%20in%20the%20VBA.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22References2003_1.png%22%20style%3D%22width%3A%20447px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199227i6282EDF4FF4A298D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22References2003_1.png%22%20alt%3D%22References2003_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1470828%22%20slang%3D%22en-US%22%3ERe%3A%20An%20Access%20Program%20No%20Longer%20Responds%20after%20MS%20Tech%20Changed%20Registry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1470828%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F46682%22%20target%3D%22_blank%22%3E%40George%20Hepworth%3C%2FA%3E%26nbsp%3BThanks%20for%20your%20responses%20George.%20After%20I%20got%20over%20being%20so%20pissed-off%20at%20the%20MS%20tech%20(which%20took%20me%20about%20an%20hour)%2C%20I%20did%20some%20checking.%20What%20I%20found%20was%20that%20he%20apparently%20reset%20the%20registry%20settings%20for%20the%20Access%20Trust%20Center.%20Since%20the%20folder%20where%20our%20program%20operates%20was%20no%20longer%20trusted%2C%20nothing%20worked.%20I%20restored%20the%20%22Trusted%20Locations%22%20and%20some%20other%20settings%20there%20and%20the%20program%20again%20works%20correctly.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBTW%2C%20the%20reason%20I%20had%20to%20contact%20MS%20in%20the%20first%20place%20was%20a%20bad%20MS%20update%20that%20apparently%20hosed%20Access.%20This%20is%20the%20second%20time%20since%20November%20that%20MS%20has%20issued%20a%20bad%20Access%20update%20that%20impacted%20our%20%3CA%20href%3D%22https%3A%2F%2Fgeotech.com%2Fproducts%2Fenvirodata%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EEnviro%20Data%3C%2FA%3E%20program%20and%20our%20clients.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1470949%22%20slang%3D%22en-US%22%3ERe%3A%20An%20Access%20Program%20No%20Longer%20Responds%20after%20MS%20Tech%20Changed%20Registry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1470949%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F430862%22%20target%3D%22_blank%22%3E%40WalterWood44%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhile%20I'm%20happy%20to%20hear%20you%20resolved%20the%20immediate%20problem%2C%20I'm%20still%20disappointed%20in%20that%20MS%20Tech's%20actions.%20I%20can't%20imagine%20why%20anyone%20would%20even%20think%20that%20disabling%20Trusted%20Locations%20would%20help%20anything.%20It's%20intended%20to%20be%20a%20security%20measure%20to%20restrict%20access%20to%20potentially%20unsafe%20documents!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20updates%20that%20have%20been%20causing%20so%20many%20recent%20problems%20are%20a%20significant%20concern%20to%20a%20lot%20of%20people.%20Sad%20to%20say%2C%20it's%20one%20reason%20so%20many%20developers%20are%20casting%20their%20eyes%20around%20for%20potential%20non-Microsoft%20solutions.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have a program written in Access that is a front end and connects to a back end database. This is an MDB file. The program has buttons you can click to download documents from the web. The buttons were not working but everything else was working. The Tech decised to make some type of change in the Registry and now none of the buttons do not respond and I have no idea what he did. He dumped me off here to get help.

 

BTW I believe the problem I was having was related to a default app and had nothing to do with Access. I would like to strangle him!

 

Any help would be appreciated.

TIA
Walter

4 Replies
Highlighted

@walterwood442320 That's an unfortunate situation. However, no one here can possibly know what changes were made to your registry, nor why they were made. It's especially unfortunate that someone working for Microsoft "dumped you off here" rather than taking responsibility for the action.

 

We can offer some suggestions about things to try, but realistically, not having any idea what those registry changes were makes it difficult.

 

For starters, can you open a VBA module and compile the code?


Highlighted

@George Hepworth 

 

Here's a screenshot of the Compile Action. Do this and see what errors are raised.

CompileVBA.png

 

Also check the references in the VBA.

 

References2003_1.png

Highlighted

@George Hepworth Thanks for your responses George. After I got over being so pissed-off at the MS tech (which took me about an hour), I did some checking. What I found was that he apparently reset the registry settings for the Access Trust Center. Since the folder where our program operates was no longer trusted, nothing worked. I restored the "Trusted Locations" and some other settings there and the program again works correctly. 

 

BTW, the reason I had to contact MS in the first place was a bad MS update that apparently hosed Access. This is the second time since November that MS has issued a bad Access update that impacted our Enviro Data program and our clients. 

Highlighted

@WalterWood44 

 

While I'm happy to hear you resolved the immediate problem, I'm still disappointed in that MS Tech's actions. I can't imagine why anyone would even think that disabling Trusted Locations would help anything. It's intended to be a security measure to restrict access to potentially unsafe documents!

 

The updates that have been causing so many recent problems are a significant concern to a lot of people. Sad to say, it's one reason so many developers are casting their eyes around for potential non-Microsoft solutions.