# Identify tables in MSACCESS database . . . msysobjects

**URL:** <https://forum.knime.com/t/identify-tables-in-msaccess-database-msysobjects/46144>\
**Category:** KNIME Analytics Platform\
**Tags:** database\
**Created:** [August 19, 2022, 5:37pm UTC](https://forum.knime.com/t/identify-tables-in-msaccess-database-msysobjects/46144 "2022-08-19T17:37:32Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![MichaelRespondek](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/6de8d8/32.png) [@MichaelRespondek](https://forum.knime.com/u/MichaelRespondek)\
**Post date:** [August 22, 2022, 3:15pm UTC](https://forum.knime.com/t/identify-tables-in-msaccess-database-msysobjects/46144/2 "2022-08-22T15:15:17Z")

</div>

Hi @sanderlenselink,

It’s been quite a while since I last used MS Access and have currently no access to the application so I had to google it. It seems that since the MSysObjects is a system table it is not accessible for access via SQL or it has to addressed differently.

What you could try mentioned as solutions in my findings for SQL requests:  
a) Address the table as sys.MSysObjects or use  
b) “SELECT \* FROM information\_schema.tables”

After downloading an Access sample db I checked both, while a) gave me an error that “SYS” is an invalid schema name, even after setting sysSchema=true in jdbc parameters b) succeeded and provided useful details.

Hope this helps you,  
Best,  
Michael

---

_[View the full topic](https://forum.knime.com/t/identify-tables-in-msaccess-database-msysobjects/46144)._
