# \#ms-access

**URL:** https://community.cdata.com/tag/ms-access/186.md

[Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md)

---

## [How to Manage Multiple Attachments in Kintone Using the CData Kintone JDBC Driver](https://community.cdata.com/t/how-to-manage-multiple-attachments-in-kintone-using-the-cdata-kintone-jdbc-driver/1231)

<div class="topic-metadata">

**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\
**Replies:** 0\
**Last updated:** [November 6, 2025, 5:01am UTC](https://community.cdata.com/t/how-to-manage-multiple-attachments-in-kintone-using-the-cdata-kintone-jdbc-driver/1231 "2025-11-06T05:01:41Z")

</div>

Hey CData Community! Ever found yourself wrestling with attachments in Kintone and thought, “there’s gotta be an easier way”? Good news: we just dropped a guide on how to bulk upload/delete/manage multiple files in Kin…

---

## [Optimize Microsoft Access with SQL Pass-Through Queries](https://community.cdata.com/t/optimize-microsoft-access-with-sql-pass-through-queries/1038)

<div class="topic-metadata">

**Author:** [@Mohsin](https://community.cdata.com/u/Mohsin)\
**Replies:** 0\
**Last updated:** [March 10, 2025, 8:02am UTC](https://community.cdata.com/t/optimize-microsoft-access-with-sql-pass-through-queries/1038 "2025-03-10T08:02:53Z")

</div>

Looking to enhance performance in Microsoft Access? Learn how SQL pass-through queries can help you execute SQL directly on external databases, reducing bottlenecks and improving efficiency. Go beyond the native capabil…

---

## [“… is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.“ error when using ODBC drivers in MS Access](https://community.cdata.com/t/is-not-a-valid-name-make-sure-that-it-does-not-include-invalid-characters-or-punctuation-and-that-it-is-not-too-long-error-when-using-odbc-drivers-in-ms-access/441)

<div class="topic-metadata">

**Author:** [@kristinab](https://community.cdata.com/u/kristinab)\
**Replies:** 0\
**Last updated:** [October 6, 2023, 5:44pm UTC](https://community.cdata.com/t/is-not-a-valid-name-make-sure-that-it-does-not-include-invalid-characters-or-punctuation-and-that-it-is-not-too-long-error-when-using-odbc-drivers-in-ms-access/441 "2023-10-06T17:44:47Z")

</div>

This error typically occurs when tables intended to be imported, contain special characters in their table names or columns, such as square brackets, dots etc. To illustrate the issue at hand, I have utilized the CData O…

---

## [Cannot perform JOINs when querying from Microsoft Access](https://community.cdata.com/t/cannot-perform-joins-when-querying-from-microsoft-access/254)

<div class="topic-metadata">

**Author:** [@Dardi\_R](https://community.cdata.com/u/Dardi_R)\
**Replies:** 0\
**Last updated:** [July 12, 2023, 8:38pm UTC](https://community.cdata.com/t/cannot-perform-joins-when-querying-from-microsoft-access/254 "2023-07-12T20:38:12Z")

</div>

Microsoft Access does consider Varchar types with a size greater than 255 as Memo objects. However, Memo objects cannot be used as JOIN conditions. In such scenarios the query will fail with the following error: “Cannot …

---

## [Executing an ODBC driver’s stored procedures in Microsoft Access](https://community.cdata.com/t/executing-an-odbc-driver-s-stored-procedures-in-microsoft-access/250)

<div class="topic-metadata">

**Author:** [@Elizabeth\_G](https://community.cdata.com/u/Elizabeth_G)\
**Replies:** 0\
**Last updated:** [July 11, 2023, 9:10pm UTC](https://community.cdata.com/t/executing-an-odbc-driver-s-stored-procedures-in-microsoft-access/250 "2023-07-11T21:10:12Z")

</div>

If you are using an ODBC driver and wish to execute one of its stored procedures in Access, you will need to go to Create → Query Design, and select Pass-Through. You can then write the query for the stored procedure, su…

---

## [Executing an ODBC driver's stored procedures in Microsoft Access](https://community.cdata.com/t/executing-an-odbc-drivers-stored-procedures-in-microsoft-access/231)

<div class="topic-metadata">

**Author:** [@Elizabeth\_G](https://community.cdata.com/u/Elizabeth_G)\
**Replies:** 0\
**Last updated:** [June 30, 2023, 3:53pm UTC](https://community.cdata.com/t/executing-an-odbc-drivers-stored-procedures-in-microsoft-access/231 "2023-06-30T15:53:55Z")

</div>

If you are using an ODBC driver and wish to execute one of its stored procedures in Access, you will need to go to Create → Query Design, and select Pass-Through. You can then write the query for the stored procedure, su…
