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
Home » 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