<div>
I get the following error when I run that query<br />
<br />
Record(s) cannot be read; no read permission on 'MsysObjects'.
</div>


I get the following error when I run that query

Record(s) cannot be read; no read permission on 'MsysObjects'.

<div>
you may have to login as an admin or granted read permission on system tables
</div>


you may have to login as an admin or granted read permission on system tables

<div>
How do I login as admin on an access database?<br />
<br />
I am local admin on the machine (db file is on c:\ drive) with no password set
</div>


How do I login as admin on an access database?

I am local admin on the machine (db file is on c:\ drive) with no password set

<div>
in access, go to tools\security\user and group permissions<br />
<br />
check what is the current user you're using
</div>


in access, go to tools\security\user and group permissions

check what is the current user you're using

<div>
<div class="content wysiwyg-content">
Is there a way I can list all the tables in an Access database using a SQL query?<br />
SImilar to the SQL Server:<br />
select TABLE_NAME from INFORMATION_SCHEMA.TABLES <br />
<br />
But something that will work on Access
</div>
</div>


Is there a way I can list all the tables in an Access database using a SQL query?
SImilar to the SQL Server:
select TABLE_NAME from INFORMATION_SCHEMA.TABLES 

But something that will work on Access

List all tables in an Access database

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.