> ## Documentation Index
> Fetch the complete documentation index at: https://docs.pads4.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Connecting a Microsoft Access Database

The **Microsoft Access provider type** allows **PADS4** to connect to **Microsoft Access databases** (**Office 2010 or earlier**).

***

### **Requirements**

* **Office System Drivers**
  * If you're using **Windows 7** or certain other Windows versions, you may need to **install the Office System drivers** before connecting to a **Microsoft Access database**.
  * These drivers are available **for free** on the **Microsoft website**.

***

### **Steps to Connect to a Microsoft Access Database**

#### **1. Start the Data Provider Wizard**

* Open the **Data Provider Wizard** by following the instructions in **Adding a Data Provider** or **Editing a Data Provider**.
* Select **Microsoft Access** as the **provider type**.

***

#### **2. Specify the Access Database File Location**

* Choose between:
  * **Content Library** (Recommended) → Uses a database stored in the **PADS4 Content Library**.
  * **File Name** → Uses a database **outside the Content Library** (must specify the full file path).
* Click **Browse** to locate and select the **.mdb** or **.accdb** file.

**For Protected Databases:**

* If your database requires authentication, enter the **Login Name** and **Password**.
* Click **Test** to verify the connection.

***

#### **3. Select the Data Source**

* Choose the type of data to retrieve:
  * **Tables** – Select a table from the dropdown list.
  * **Queries** – Select a query that already exists in the database.
  * **Parameter Queries** – If your query requires parameters, configure them accordingly.
  * **SQL Statement** – Manually enter an **SQL query** (Only use this if no predefined tables or queries meet your needs).

**Tip:**\
Using **SQL Statements** may reduce performance since they need to be **validated every time** data is retrieved.

***

#### **4. Complete the Setup**

* Click **Next** to proceed.
* Finish the setup by completing the **Data Provider Wizard**.

***

### **Important Considerations**

* **Using a PADS4 Data Server**
  * If a **PADS4 Data Server** is in use, ensure that the **Office System drivers** are **installed on the server**.
  * The **Access database must be accessible** from the **server’s point of view**.
* **Without a PADS4 Data Server**
  * Ensure that **PADS4 Designer** (for previewing) and **PADS4 Viewers** have the **Office System drivers installed**.
  * Confirm that **each Viewer can access the database**.
* **Avoid Using Shared Network Folders**
  * **Using a shared network folder** (via a **mapped drive** or **UNC path**) for an **Access database** can cause **high network traffic** whenever data is refreshed.
  * It's **recommended** to **store the database in the PADS4 Content Library** or use **a centralized SQL database** for better performance.

***

By following these steps, PADS4 can successfully connect to a **Microsoft Access database** and retrieve real-time data.