SELECT Table_Name = Name, Row_Count = DCount("*",[MSysObjects].[Name]) FROM MSysObjects WHERE (Left([Name],1)<>"~") AND (Left([Name],4) <> "MSys") AND ([Type] In (1, 4, 6)) ORDER BY Name
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)