• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2324
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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