Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2337
  • Last Modified:

List all tables in an Access database

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
MattWilkinson
Asked:
MattWilkinson
  • 3
  • 2
2 Solutions
 
jamesguCommented:
SELECT *
FROM MsysObjects
where type = 1
0
 
MattWilkinsonAuthor Commented:
I get the following error when I run that query

Record(s) cannot be read; no read permission on 'MsysObjects'.
0
 
jamesguCommented:
you may have to login as an admin or granted read permission on system tables
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
Rey Obrero (Capricorn1)Commented:
select [name] from msysobjects
where [name] not like 'msys*' and type=1
0
 
MattWilkinsonAuthor Commented:
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
 
jamesguCommented:
in access, go to tools\security\user and group permissions

check what is the current user you're using
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now