Connector Details

Connector Attributes	Details
Name	Microsoft Access
Description	Microsoft Access is a powerful relational database management system (RDBMS) that provides individuals and organizations with an intuitive platform for creating, managing, and analyzing data. With its user-friendly interface and robust features, Access allows users to build custom database applications without the need for advanced programming skills. Users can easily design tables, forms, queries, and reports to organize and manipulate data according to their specific requirements. Access also offers integration with other Microsoft Office applications, enabling seamless data sharing and collaboration across different platforms. Whether used for personal projects, small businesses, or enterprise solutions, Microsoft Access serves as a versatile and scalable solution for effectively managing data and improving productivity.
Connector Type	Class B

Features

Feature Name	Feature Details
Load Strategies	Full Load
Metadata Extraction	Supported
Data Acquisition	Supported
Data Publishing	Not Supported
Automated Schema Drift Handling	Not Supported

Microsoft Access connector has optional values such as Bronze Schema and Silver Schema
Source Configuration to place the access file.
The access file needs to exist in a file location accessible from the Databricks workspace file system.
a) Any location on DBFS
b) Any directory in the attached data lake which is mounted to the Databricks workspace.