Setting up trust for access applications to be used on runtime target systems

I had used a vbscript file that altered setting in the USER registry. Typically, users have the right to update USER settings. The vbscript file was part of a batch file that altered the registry, created the application directory, copied the latest app file, and then opened it. The below code is quite old and matched earlier versions of MS Office.

I wasn't allowed to post the code but it can be found at Tek-Tips FAQ. The [color] tags on the page aren't rendering correctly so you would need to delete all of them. Also, the "SNOW" referred to a standard operating system used at a previous client.

Just curious, do your users not get a warning dialog box about your app with a button to open it or cancel? What do they actually see? Does the app just quits or do they get a warning box with just an ok button on it?

Dear @Stephan Aal

Thank you so much for contacting Microsoft Q&A Forum. 

Based on your description, it sounds like your Microsoft Access application using the Access Runtime, you need to ensure the application is located in a trusted location. Since runtime users can't access the Trust Center UI, this must be done via the Windows Registry. Access Runtime disables macros and VBA unless the database is in a trusted location. Without this, users will see security warnings, or the application may not function properly. Therefore, I recommend that you should manually or programmatically add a trusted location using the Windows Registry.  

Kindly notes:  

• Use the appropriate registry path depending on the version of Office installed. 
• Machine-Wide Setup (Optional): if you want this to apply to all users on a machine, use HKEY_LOCAL_MACHINE instead of HKEY_CURRENT_USER. 

Also, I have found several scenarios that have partially similar to your case and you can consult in there:

• Add or Remove Registry Keys after Installing or Removing Components - Win32 apps | Microsoft Learn 
• Check and add a trusted location to access and the runtime versions automatically when it starts - Microsoft Q&A 
• Microsoft Access Runtime Trusted Location - Microsoft Q&A 
• add trusted locations in access - Microsoft Q&A 
• Trusted Location - Microsoft Q&A 

I hope this information can help you to finish this work. 

Wish you a pleasant day!

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.