Solved

List all tables in an Access database

Posted on 2008-10-09
8
2,296 Views
Last Modified: 2013-11-29
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
0
Comment
Question by:MattWilkinson
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
8 Comments
 
LVL 9

Accepted Solution

by:
jamesgu earned 125 total points
ID: 22680344
SELECT *
FROM MsysObjects
where type = 1
0
 

Author Comment

by:MattWilkinson
ID: 22680416
I get the following error when I run that query

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

Expert Comment

by:jamesgu
ID: 22680460
you may have to login as an admin or granted read permission on system tables
0
What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 125 total points
ID: 22680476
select [name] from msysobjects
where [name] not like 'msys*' and type=1
0
 

Author Comment

by:MattWilkinson
ID: 22680500
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
0
 
LVL 9

Expert Comment

by:jamesgu
ID: 22686904
in access, go to tools\security\user and group permissions

check what is the current user you're using
0

Featured Post

How To Install Bash on Windows 10

Windows’ budding partnership with Canonical has certainly led to some great improvements. One of them being the ability to use Bash on your Windows machine without third party applications! This might be one of the greatest things a cloud engineer in a Windows environment can do!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question