谁链接到我的MS Access表? [英] Who's linking to my MS Access tables?

问题描述

我们有一个MS数据库(.mdb文件)，网络上的许多人都在大量访问它.但是，此文件即将被移动，我们不知道在发生移动之前需要通知谁.

We've got a MS Database (.mdb file) that is heavily accessed by many people on the network. However, this file is going to be moved soon and we don't know who we need to inform before the move occurs.

是否有开始记录所有间接访问该数据库的人的日志?

Is there anyway to start keeping a log of everyone who accesses this database indirectly?

我们有一个VBA脚本，当直接打开数据库以记录重要信息时会触发，因此我们可以与他们联系，但我们发现大多数用户实际上并未打开数据库，而是他们在使用本地数据库自己链接到主数据库.

We've got a VBA script that fires when the database is opened directly to record important information so we can contact them but we've found majority of the users don't actually open the database, instead they are using local databases of their own that are LINKED to the main database.

大多数数据库都是使用.acccdb扩展名的2007/2010.仅此主数据库"使用旧的.mdb扩展名.

Most databases are either 2007/2010 using the .acccdb extension. Only this "main database" is using the old .mdb extension.

有什么建议吗?

推荐答案

使用文件系统及其网络重定向器提供的数据库原语访问数据库.因此，文件系统和网络重定向器始终知道谁在访问文件(实际上，谁在访问文件内部的物理记录).

The database is accessed using the database primitives provided by the file system and it's network re-director. So the file system and the network re-director always know who is accessing the file (and, actually, who is accessing the physical records inside the file).

记录此问题的一种简单方法是使用文件服务器上Windows事件日志系统中的安全日志.为此，选择数据库文件，右键单击，然后选择属性"，安全性"，高级"，然后选择审核"选项卡.将所有人"添加到审核列表中.我也将添加匿名"，但是如果您获得任何匿名"访问权限，则将遇到更大的问题.

An easy way to to log this is to use the Security Log in the Windows Event Log system on the File Server. To do this, select the database file, right click, and select "properties", "Security", "Advanced" then the Auditing tab. Add "everyone" to the audit list. I would add "anonymous" as well, but if you get any "anonymous" access, you've got bigger problems.

您还需要通过组策略(在域系统上)或本地策略(在没有组策略的系统/网络/工作组中的文件服务器上)启用对象"的审核日志记录.您需要的是Windows设置>安全设置>本地策略>审核策略>审核对象访问

You also need to enable audit logging of "objects", through group policy (on a domain system) or local policy (on a file server in system/network/workgroup without group policy). The one you want is Windows Settings > Security Settings > Local Policies > Audit Policy > Audit Object Access

您需要启用的日志(将获取此信息)是存储数据库文件的服务器上的日志.它是在文件端(一个地方)而不是在请求端(可能在任何地方)记录访问权限.

The log that you need to enable, that will get this information, is the log on server where the database file is stored. It's logging access at the file end (which is one place) not at the request end (which could be anywhere).

编辑> 要从日志中查询和导出，如果其中一台服务器上有副本，则可以使用"eventquery.vbs".它在WMI对象上使用execquery.如果您没有eventquery.vbs，则可能需要寻找PowerShell的替代方案.

edit> To query and export from the log, you can use "eventquery.vbs", if you've got a copy on one of your servers. It uses execquery on a WMI object. If you haven't got eventquery.vbs, you may want to look for a PowerShell alternative.

这篇关于谁链接到我的MS Access表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！