Microsoft Access Read Permission

[danchips24]

Hi,

I am working with a Microsoft access file and am trying to read in all the table names to then leverage a dynamic input tool to input data from all tables within the file. when i use the following query i receive the below error:

Query

SELECT MSysObjects.Name AS table_name

FROM MSysObjects

WHERE (((Left([Name],1))<>"~")

AND ((Left([Name],4))<>"MSys")

AND ((MSysObjects.Type) In (1,4,6)))

order by MSysObjects.Name

Error

error: microsoft access database engine: record(s) cannot be reas; no read permission on 'msysobjects'

Can someone direct me on how to obtain read permission so that i can leverage the data?

Thanks in advance!

[VianneyM · Accepted solution]

hi @danchips24,

Read permissions have to be granted by your Access Database administrator/ IT team. From Alteryx you can't change those permissions 

Best,

Vianney