Solved

List all tables in an Access database

Posted on 2008-10-09
8
2,282 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
  • 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 Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 119

Assisted Solution

by:Rey Obrero
Rey Obrero 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

747 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now