设置 Microsoft Access 连接器：数据库引擎和文件路径

连接器设置 · Microsoft Access

设置 Microsoft Access 连接器

Access 连接能否成功取决于两个因素：代理计算机上的数据库引擎以及代理可以打开的文件路径。本页将介绍这两个方面。

大约10分钟 Windows 代理 文件位置不变

你最终会得到什么

在 Microsoft Access 连接中 数据代理 测试 已连接适用于 Excel、Google Sheets、AI 助手或 REST API。代理会读取您的数据。 .accdb 或 .mdb 文件保留在原处；不会复制或转换任何内容。

经纪人需要什么

安装数据库引擎

The engine is required even when Microsoft Access or Office is already installed. Office installed through Click-to-Run registers its engine for Office alone, so the Agent cannot use it. If the Agent’s computer has 32-bit Office, do not install anything on it: read If the installer stops with a message about 32-bit Office 第一的。

1. 下载 64 位安装程序

   打开 Microsoft Access 数据库引擎 2016 可再发行组件包 on Microsoft’s site, on the Agent’s computer if you can. The page shows a Select language drop-down (leave it on English) and a red 下载 button. Click 下载.

   A box titled Choose the download you want opens with two files and a tick box beside each. Tick 仅有的 accessdatabaseengine_X64.exe. The other one, accessdatabaseengine.exe with no X64, is the 32-bit file and will not work with the Agent, even on a computer with 32-bit Office. Then click the 下载 button in that box.

   Edge and Chrome show the download at the top right of the browser window; it lands in your Downloads folder as accessdatabaseengine_X64.exe. If you clicked Download without ticking anything, or you see a file called just accessdatabaseengine.exe, you probably got the 32-bit file: delete it and do this step again.

2. 在特工的电脑上运行它

   Double-click the downloaded file. If Windows asks Do you want to allow this app to make changes to your device?， 点击 是. Then click 下一页, tick the licence box and click 下一页 again, click 安装然后点击 好的 或 结束 when it says the installation is complete.

   If instead it stops with a message that starts You cannot install the 64-bit version of Microsoft Access Database Engine 2016 because you currently have 32-bit Office products installed， 点击 好的 to close it and delete the file you downloaded. This computer cannot run the Access connector: the Agent has to go on a computer without 32-bit Office. Follow the steps below. Do not try to force the installer through.

3. 在门户网站中点击“重新检查”。

   返回连接器表单，单击 重新检查横幅会变成绿色，并显示找到的引擎名称，例如： Microsoft.ACE.OLEDB.16.0连接测试结果仍然具有最终决定权，因此请继续执行文件路径设置。

   If the banner stays grey and says 无法验证 Access 数据库引擎, the Agent is not connected. Follow Is the Agent online?然后点击 重新检查 again.

Is the Agent online?

Re-check, Browse and Test connection all run on the Agent’s computer, so they need the Agent connected: a green dot by its name in 数据代理 means 在线. If it is red and says Offline, follow Is the Agent online? (computer asleep, service stopped, or no internet), then come back and click 重新检查.

If the installer stops with a message about 32-bit Office

This happens on many computers that have Word, Excel or Outlook installed, because Office is often the 32-bit kind. When the Agent finds 32-bit Office, the connector form says so too, before you install anything.

Why it happens. 32-bit Office comes with a 32-bit database engine. The Agent is a 64-bit program and can only use the 64-bit engine. Microsoft does not support both engines on one computer, and forcing the 64-bit one in can stop Microsoft Access from opening. So the Agent cannot read Access files on this computer.

The fix: run the Agent on a different computer. Use a computer without 32-bit Office, install the Agent and the 64-bit engine there, and point the connector at the database over the network. Nothing changes on the computer with 32-bit Office.

1. Choose a computer without 32-bit Office

   Pick a Windows computer that stays switched on and can reach the folder that holds the database. A Windows server is ideal. A desktop computer with 64-bit Office, or with no Office at all, works too. If the database already sits on an office file server, that server is often the best choice: the file is then a plain local path to the Agent.

   To check which Office a computer has, open Word or Excel on it, click 文件然后 帐户然后 About Word （或） About Excel). The box that opens shows the version followed by 32-bit 或 64-bit.

2. Install the Agent there

   On that computer, follow 在 Windows 上安装代理. When it finishes, the new Agent shows a green dot in 数据代理.

   Each Agent counts toward your plan. If setup says all of your plan’s Agents are in use, delete the Agent you no longer need in 数据代理 第一的。

3. Install the 64-bit engine there

   On the same computer, do steps 1 and 2 above: download accessdatabaseengine_X64.exe and run it. This time the installer finishes without the 32-bit Office message.

4. Point the connector at the database by its network path

   在 数据代理, add the Microsoft Access connector on the 新的 Agent. In 数据库文件路径, enter the database as a share path, \\server\share\folder\file.accdb， 例如 \\FILESERVER\Shared\Accounts\orders.accdb. A drive letter like S： does not work; here is how to find the path behind it. If the file is on the new computer itself, a local path such as D:\Data\orders.accdb is fine.

   If the share only lets in named users, click the chip under the path and store a sign-in for that server: Signing in to the file server. Then click 重新检查 和 测试连接读到 已连接， 点击 节省.

   If the database sits on the computer with 32-bit Office, its folder has to be shared on the network first, or the file moved to the new computer. Whoever looks after your computers can do either.

Getting Access back if the 2016 engine broke it

If Microsoft Access stopped opening after a 64-bit 2016 engine was installed next to 32-bit Office, undo it in two steps. Both are in Settings → Apps → Installed apps (on older Windows 10, Apps & features).

1. Uninstall the 2016 engine

   In the search box type Access database engine, click the … (or the entry) beside Microsoft Access database engine 2016, and choose Uninstall.

2. Repair Office

   In the same list find Microsoft 365 或 Microsoft Office， 选择 Modify， 挑选 Quick Repair 并点击 Repair. It takes a few minutes. Open Access to confirm it starts. If it still does not, run Modify again and pick Online Repair (slower; needs internet).

3. Run the Agent on a different computer

   Do not install any engine on this computer again. Set the Agent up on a computer without 32-bit Office instead: follow the steps above.

文件可以放在哪里？

代理程序会将文件作为 Windows 服务打开。这会改变有效路径的定义：

Signing in to the file server

If the share only lets in named people, store a username and password for that server on the connector. The Agent signs in to the server with it and reads the live database file there.

Why this is needed: the Agent runs as a Windows service under the built-in Local System account, not as you. On a company domain the file server sees it as the computer’s own account, the computer name with a dollar sign, for example RECEPTION$. On a home or small-office network without a domain it is nobody the server knows. Either way, a share that is permissioned per user turns it away, and the path check under the file box says:

Access denied for the agent's service account. Add share credentials to this connector, or grant the agent's computer account read access.

There are two ways to fix it:

1. Type the share path

   在 数据库文件路径, enter the full network path, for example \\192.168.1.125\Access\TestDB.accdb. As soon as the path starts with two backslashes, a small chip appears under the box, followed by the server name. It reads Service identity while nothing is stored, meaning the Agent tries its own Windows account. If the path check already said access was denied, a rose button Enter credentials for \\192.168.1.125 appears next to it.

2. Click the chip and fill in the box

   Click the chip, or the rose button. A box titled Credentials for \\192.168.1.125 opens, with the line Credentials for this file’s server under the title.

   Domain

   Your company’s Windows domain, for example CORP. For an account that exists only on the file server itself, leave it blank or type a full stop (.).

   用户名

   Required. An account that can read the share. As the box says, Use a least-privilege, read-only account. A dedicated account such as svc-qs-readonly is better than a person’s login, because it will not change when someone leaves. It does need one write permission, explained in the note below.

   密码

   Required the first time. It is Used only to read this file; stored with the connector.

   点击 节省. The chip now shows the account, for example .\systemz 或 CORP\svc-qs-readonly.

3. Check the line under the path

   The Agent checks the path again with the new account. A green tick and File is reachable with the stored credential means the server let the account in and the file is there. Then click 测试连接. On success the result adds a line such as Reading the live file on \\192.168.1.125 as .\systemz点击 节省 on the connector.

If your file is on a drive letter like S: or Z:

A drive letter like S： is a shortcut that exists only while you are signed in. The Agent runs in the background as a Windows service, before anyone signs in, so it has never seen that shortcut. The real location behind the letter, a network path that starts with two backslashes like \\FILESERVER\Shared, works for both of you. The steps below find that path and put it in the right place.

1. See what the letter points to

   打开 File Explorer (the yellow folder icon on the taskbar, or press the Windows key and E together) and click This PC in the list on the left. Scroll to the heading Network locations. Each mapped drive is listed there with its real path in its name, in this shape: Shared (\\FILESERVER) (S:). The two parts you need are the server name inside the brackets, FILESERVER, and the share name before them, 共享. Write both down.

   If the name has been changed to something like Accounts drive (S:) and the brackets are missing, use one of the other two ways:

   From the address bar. Open the folder that holds your Access file. At the top of File Explorer, click once in the empty space of the address bar; it changes from This PC › Shared (S:) › Accounts to a typed path. If the path starts with two backslashes, that is the one you want: select it all and copy it. If it still shows S:\Accounts, use the next way.

   From Command Prompt. 点击 Start, type cmd然后点击 Command Prompt (a normal click this time; no administrator needed). In the black window, type the line below and press Enter:

   Type this, then press Enter

   net use

   A short table appears. Find the row whose 当地的 column says S：; its Remote column is the network path, for example \\FILESERVER\Shared. Write that down and close the window.

2. Build the full path to the file

   Take the network path from step 1 and add everything that came after the drive letter, folders and file name included:

   你所看到的

   S:\Accounts\orders.accdb

   What to type

   \\FILESERVER\Shared\Accounts\orders.accdb

   只有 S： part changes; the folders and the file name stay exactly as they were.

3. Put it in the Portal

   In the connector form, type or paste the full path straight into the 数据库文件路径 box. Or click Browse: the Browse dialog does not list mapped letters (it says Mapped drives (like Z:) are not shown and explains why). Click in the box at the bottom that reads Type a folder or full file path on the agent, type the share part, \\FILESERVER\Shared, and press Enter. The folder opens through the Agent and you can click down to the file.

4. 测试连接

   点击 测试连接. 已连接 means you are done; click 节省.

   If the line under the path says Access denied for the agent’s service account, the Agent reached the server but was not let in. The mapped drive worked for you because Windows signed you in to the server; the Agent has to sign in on its own. Click the chip under the path and store an account that can read the share, as described in Signing in to the file server, then test again.

添加连接

打开 数据代理 （在下面 数据 点击顶部菜单中的按钮）， 添加连接器 在您的代理人处，选择 Microsoft Access并填写：

数据库文件路径

The file’s location on the Agent’s computer, as described above. Click Browse and click down to the file. To type it instead: in File Explorer hold Shift and right-click the file, choose Copy as path, paste into the box, and delete the quotation mark at each end.

Share sign-in chip

Appears under the path only for a \\server\share path. Leave it on Service identity unless the share needs a named account (details).

密码

Only if the database itself has a database password set in Access. This is not the share password; that one goes in the chip.

只读模式

默认开启。请保持开启状态；它允许代理程序读取其他程序打开的文件。

连接超时（秒）

30 就足够了。只有在网络共享速度慢的情况下才需要提高这个值。

点击 测试连接当它读到 已连接， 点击 节省.

测试失败？

测试结果下方的信息会告诉你具体是哪一种。

接下来：使用数据

• 将 Microsoft Access 转换为 Excel
• Microsoft Access 到 Google Sheets
• Claude 和其他 AI 助手中的 Microsoft Access (MCP)
• Microsoft Access 作为 REST API

相关指南

• 在 Windows 上安装代理
• https://querystreams.com/id/docs/sql-for-data-analysts/feed/
• 所有指南