# Microsoft Access

## Microsoft Access

When creating new database connection, specify the database path to the .mdb or .accdb file in database name field.

This database connection uses the UCanAccess driver which works well for reading with TableInput, DatabaseLookup, but it’s not great for writing. For writing it is better to use the Microsoft Access Output transformation.

| Option           | Info                                                                         |
| ---------------- | ---------------------------------------------------------------------------- |
| Type             | Relational                                                                   |
| Driver           | Included                                                                     |
| Version Included | 5.1.3                                                                        |
| Hop Dependencies | None                                                                         |
| Documentation    | [Documentation Link](https://spannm.github.io/ucanaccess/10-ucanaccess.html) |
| JDBC Url         | jdbc:ucanaccess\://path.mdb                                                  |
| Driver folder    | \<Hop Installation>/lib/jdbc                                                 |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.primeur.com/data-shaper-1.21/knowing-the-data-shaper-designer/relational-database-connections/access.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.