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