Re: [MSAccessProfessionals] Access Runtime Issues: Warnings and Macros

Duane,

 

The warnings thing makes sense. I’ll try that. Would you happen to have a sample vbscript to set trusted folders. I did some registry edits to set trusted folders. I’m not sure if its that or the macro settings that are generating the security warning. I’d like to enable macros automatically and not get the warning.

 

Doyce Winberry

Manufacturing

Manager Systems

 

XPOLogistics

2001 Benton Street

Searcy, AR 72143 USA

O: +1 501-207-5973   M: +1 501-207-2269

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Tuesday, October 13, 2020 2:40 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Access Runtime Issues: Warnings and Macros

 

[Warning: External sender, “Report Phish” for suspicious emails]

 

Hi Doyce,

I typically set warnings off and on immediately before and after running action queries. You can also use the Execute method.

 

You can run a vbscript to set/change your trusted folders.

 

Duane

 

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Doyce Winberry <doyce.winberry@xpo.com>
Sent: Tuesday, October 13, 2020 2:29 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Access Runtime Issues: Warnings and Macros

 

Hello friends, 
I'm using Office 2016 and my company is cutting back on Office E3 licenses so I'm starting to work with the latest Access Runtime testing my accde files. So far, my first issue is the security warning "A potential security concern has been identified" message when the accde file is open. I click open but would really like for it to go away. In full Access, I setup trusted locations and enable macros. Also, I turn off warnings for action queries. For the runtime version I put the following code in the load event of the switchboard, docmd.setwarnings false. However, I'm still getting messages like I'm about to delete 55 records out of a temp table. What do I need to do to make that go away also?
Doyce 

 

[Do not open attachments or click links unless you can verify the sender. Click “Report Phishing” if the email looks suspicious.]