Connector Microsoft Access - Document Details

About This Page

This page is part of the Azure documentation. It contains code examples and configuration instructions for working with Azure services.

View on GitHub 📚 View on Microsoft Learn

Bias Analysis

Detected Bias Types

windows_tools

missing_linux_example

windows_first

Summary

The documentation demonstrates a Windows bias by exclusively referencing the Microsoft Access ODBC driver, which is only available on Windows. All example connection strings use Windows-style file paths (e.g., C:\mydatabase.accdb), and there is no mention of Linux or cross-platform alternatives for running the Integration Runtime or accessing Microsoft Access data. The prerequisites and setup instructions implicitly assume a Windows environment, and there are no examples or guidance for Linux users.

Recommendations

Explicitly state that the Microsoft Access ODBC driver is only available on Windows, and clarify platform limitations in the prerequisites.
If possible, provide guidance or workarounds for Linux users, such as using third-party ODBC drivers (e.g., MDBTools) or running the Integration Runtime in a Windows container/VM on Linux.
Include example connection strings and file paths for both Windows and Linux (if supported), or clearly indicate that only Windows is supported.
Add a section addressing cross-platform considerations and alternatives for non-Windows environments.

Create Pull Request

Scan History

Date	Scan	Status	Result
2026-01-14 00:00	#250	in_progress	Clean
2026-01-13 00:00	#246	completed	Clean
2026-01-11 00:00	#240	completed	Clean
2026-01-10 00:00	#237	completed	Clean
2026-01-09 00:34	#234	completed	Clean
2026-01-08 00:53	#231	completed	Clean
2026-01-06 18:15	#225	cancelled	Clean
2025-09-16 00:00	#113	completed	Clean
2025-09-15 00:00	#112	completed	Clean
2025-09-14 00:00	#111	completed	Clean
2025-09-13 00:00	#110	completed	Clean
2025-09-12 00:00	#109	completed	Clean
2025-09-11 00:00	#108	completed	Clean
2025-09-10 00:00	#107	completed	Clean
2025-09-09 00:00	#106	completed	Clean
2025-09-08 00:00	#105	completed	Clean
2025-08-17 00:01	#83	cancelled	Clean
2025-07-13 21:37	#48	completed	Biased
2025-07-09 13:09	#3	cancelled	Clean
2025-07-08 04:23	#2	cancelled	Biased

Flagged Code Snippets

{
    "name": "MicrosoftAccessLinkedService",
    "properties": {
        "type": "MicrosoftAccess",
        "typeProperties": {
            "connectionString": "Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=<path to your DB file e.g. C:\\mydatabase.accdb>;",
            "authenticationType": "Basic",
            "userName": "<username>",
            "password": {
                "type": "SecureString",
                "value": "<password>"
            }
        },
        "connectVia": {
            "referenceName": "<name of Integration Runtime>",
            "type": "IntegrationRuntimeReference"
        }
    }
}

"activities":[
    {
        "name": "CopyFromMicrosoftAccess",
        "type": "Copy",
        "inputs": [
            {
                "referenceName": "<Microsoft Access input dataset name>",
                "type": "DatasetReference"
            }
        ],
        "outputs": [
            {
                "referenceName": "<output dataset name>",
                "type": "DatasetReference"
            }
        ],
        "typeProperties": {
            "source": {
                "type": "MicrosoftAccessSource",
                "query": "SELECT * FROM MyTable"
            },
            "sink": {
                "type": "<sink type>"
            }
        }
    }
]

"activities":[
    {
        "name": "CopyToMicrosoftAccess",
        "type": "Copy",
        "inputs": [
            {
                "referenceName": "<input dataset name>",
                "type": "DatasetReference"
            }
        ],
        "outputs": [
            {
                "referenceName": "<Microsoft Access output dataset name>",
                "type": "DatasetReference"
            }
        ],
        "typeProperties": {
            "source": {
                "type": "<source type>"
            },
            "sink": {
                "type": "MicrosoftAccessSink"
            }
        }
    }
]