禁用通过VBA导入/链接的表的安全警告 [英] Disabling security warning on tables imported/linked via VBA

问题描述

对于通过DoCmd.TransferSpreadsheet导入的表，如何停止弹出此窗口?

How do you stop this window popping up for tables being imported via DoCmd.TransferSpreadsheet?

我要导入很多表，因此在每个弹出式窗口中都必须单击打开"很烦人.

I'm importing quite a few tables, so having to click "open" on this pop-up for each one is annoying.

我已经尝试过DoCmd.SetWarnings False，但这似乎不起作用.

I've tried DoCmd.SetWarnings False but that doesn't seem to work.

我知道也可以将包含要导入文件的文件夹设置到受信任位置，但是很遗憾，我目前没有网络权限(我也认为这样做只会影响我的Access版本的设置，而不是我正在创建和分发的Access文件).

I know that it may also be possible to set the folders that contain the files being imported to trusted locations, but unfortunately I don't have permissions on our network to do that at the moment (I also think that would only affect the settings of my version of Access rather than the Access file I'm creating and distributing).

推荐答案

我遇到的问题归因于我们的网络安全政策.我们的IT技术人员已经修改了该政策，以使我不会从尝试从特定文件夹导入到Access的文件中看到这些弹出式窗口.

The issue I was having was due to our network security policy. Our IT tech has amended the policy so that I don't get these pop-ups from files I try to import in to Access from a particular folder.

如果其他人在网络上的Access中遇到相同的问题，他会给出以下说明，尽管我怀疑这也可以通过其他Office程序来完成:

He has given the following instructions should anyone else have the same issue in Access on a network, though I suspect this could be done from other Office programs too:

对于Microsoft Active Directory域网络，添加受信任的位置 使用组策略.为组创建，链接和安全过滤 在继续操作之前，应该先熟悉策略对象，同时也要熟悉admx 使用中的MS Office版本的文件应加载到 中央商店.

For a Microsoft Active Directory domain network, add trusted locations using Group Policy. Creating, linking and security filtering for group policy objects should be familiar before continuing, also the admx files for the version of MS Office in use should be loaded in the central store.

设置在下: 用户配置/政策/行政 模板/Microsoft Access/应用程序 设置/安全性/信任中心/受信任位置

Settings are under: User configuration/Policies/Administrative Templates/Microsoft Access /Application Settings/Security/Trust Center/Trusted Locations

政策:允许网络上受信任的位置-设置为启用(必须 启用，否则网络共享上的所有受信任位置 下面指定的内容将被忽略)

Policy: Allow trusted locations on the network – set to enabled (must be enabled otherwise any trusted locations on a network share specified below will be ignored)

受信任的位置#1

1. 设置为启用
2. 路径-如果使用，则可以是网络路径(例如\\) 使用网络路径应用策略的映射驱动器号 无论如何，即使有空格也不应使用路径周围的引号 在路径名中
3. 日期-输入应该信任该位置的日期(例如， 今天的日期)
4. 说明-可选-这将显示在Access信任中心中 位置列表允许子文件夹–勾选以包括所有子文件夹 在上述路径下(如果需要)

1. Set to enabled
2. Path - can be network path (e.g. \\), if using mapped drive letter the policy is applied using the network path anyway, quotes around the path should not be used even with spaces in the path name
3. Date - enter a date from which the location should be trusted (e.g. todays date)
4. Description - optional – this will show up in Access trust centre locations list Allow subfolders – tick to include any subfolders under the above path if needed

使用受信任的位置#2，#3等添加其他位置.

Add other locations using Trusted Location #2, #3 etc.

对于独立访问，请将位置直接添加到Trust Center中 使用添加新位置"按钮进行位置对话框.如果地点 位于网络上的共享文件夹中，请确保选中该框:允许 否则，勾选了我网络上的受信任位置(不推荐) 任何网络位置都将被忽略.

For standalone Access, add the locations directly into Trust Centre locations dialogue using the Add New Location button. If the locations are in a shared folder on the network, make sure the box: Allow trusted locations on my network (not recommended) is ticked otherwise any network locations will be ignored.

这篇关于禁用通过VBA导入/链接的表的安全警告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！