Konfigurowanie łącznika Microsoft Access: Aparat bazy danych i ścieżka pliku

Konfiguracja łącznika · Microsoft Access

Skonfiguruj Microsoft Access złącze

O tym, czy połączenie z programem Access zadziała, decydują dwa czynniki: baza danych na komputerze Agenta oraz ścieżka dostępu do pliku, którą Agent może otworzyć. Ta strona omawia oba te czynniki.

Około 10 minut Agent systemu Windows Plik pozostaje tam, gdzie jest

Co z tego wyjdzie?

Połączenie Microsoft Access w Agenci danych to testy Połączony, gotowy na Excela, Arkusze Google, asystenta AI lub API REST. Agent odczytuje Twoje .accdb lub .mdb plik tam, gdzie się już znajduje; nic nie jest kopiowane ani konwertowane.

Czego potrzebuje agent

Zainstaluj silnik bazy danych

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 Pierwszy.

1. Pobierz instalator 64-bitowy

   Otwórz Moduł bazy danych Microsoft Access 2016 Redistributable 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 Pobierać button. Click Pobierać.

   A box titled Choose the download you want opens with two files and a tick box beside each. Tick tylko 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 Pobierać 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. Uruchom na komputerze agenta

   Double-click the downloaded file. If Windows asks Do you want to allow this app to make changes to your device?, kliknij Tak. Then click Następny, tick the licence box and click Następny again, click Zainstaluji kliknij OK lub Skończyć 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, kliknij OK 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. Kliknij Sprawdź ponownie w Portalu

   Wróć do formularza łącznika i kliknij Sprawdź ponownie. Baner zmienia kolor na zielony i podaje nazwę znalezionego silnika, na przykład Microsoft.ACE.OLEDB.16.0. Ostateczne zdanie należy do testu połączenia, więc przejdź do ścieżki pliku.

   If the banner stays grey and says Nie można zweryfikować modułu bazy danych Access, the Agent is not connected. Follow Is the Agent online?, a następnie kliknij Sprawdź ponownie 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 Agenci danych means Online. If it is red and says Offline, follow Is the Agent online? (computer asleep, service stopped, or no internet), then come back and click Sprawdź ponownie.

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 Plik, a następnie Konto, a następnie About Word (lub About Excel). The box that opens shows the version followed by 32-bit lub 64-bit.

2. Install the Agent there

   On that computer, follow Zainstaluj agenta w systemie Windows. When it finishes, the new Agent shows a green dot in Agenci danych.

   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 Agenci danych Pierwszy.

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

   W Agenci danych, add the Microsoft Access connector on the nowy Agent. In Ścieżka pliku bazy danych, enter the database as a share path, \\serwer\udział\folder\plik.accdb, Na przykład \\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 Sprawdź ponownie oraz Połączenie testowe; kiedy to czyta Połączony, kliknij Zapisz.

   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 lub Microsoft Office, wybierać Modify, wybierać Quick Repair i kliknij 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.

Gdzie może być plik

Agent otwiera plik jako usługę systemu Windows. To zmienia definicję prawidłowej ścieżki:

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

   W Ścieżka pliku bazy danych, 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 (.).

   Nazwa użytkownika

   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.

   Hasło

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

   Kliknij Zapisz. The chip now shows the account, for example .\systemz lub 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 Połączenie testowe. On success the result adds a line such as Reading the live file on \\192.168.1.125 as .\systemz. Kliknij Zapisz 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

   Otwórz 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, Wspólny. 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. Kliknij Start, type cmdi kliknij 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 Lokalny 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:

   Co widzisz

   S:\Accounts\orders.accdb

   What to type

   \\FILESERVER\Shared\Accounts\orders.accdb

   Tylko 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 Ścieżka pliku bazy danych 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. Przetestuj połączenie

   Kliknij Połączenie testowe. Połączony means you are done; click Zapisz.

   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.

Dodaj połączenie

Otwórz Agenci danych (pod Dane w górnym menu), kliknij Dodaj złącze w swoim agencie wybierz Microsoft Accessi wypełnij:

Ścieżka pliku bazy danych

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 \\serwer\udział path. Leave it on Service identity unless the share needs a named account (details).

Hasło

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

Tryb tylko do odczytu

Domyślnie włączone. Pozostaw włączone; to pozwala agentowi odczytać plik otwarty przez inny program.

Limit czasu połączenia (sek.)

30 jest w porządku. Podwyższaj tylko w przypadku powolnego udostępniania sieciowego.

Kliknij Połączenie testowe. Kiedy to czyta Połączony, kliknij Zapisz.

Test nieudany?

Komunikat pod wynikiem testu informuje, o który z nich chodzi.

Następne: użyj danych

• Microsoft Access do Excel
• Dostęp Microsoft do Arkuszy Google
• Microsoft Access w Claude i innych asystentach AI (MCP)
• Microsoft Access jako interfejs API REST

Powiązane przewodniki

• Zainstaluj agenta w systemie Windows
• SQLite do Microsoft Excel
• Wszystkie przewodniki