devxlogo

Find the Total Number of Tables in an MS Access Database

Find the Total Number of Tables in an MS Access Database

Use the following code to find the total number of tables in an MS Access database:

select count(name) from msysobjects where type=1 and flags=0

devx-admin

Share the Post: