G
Guest
I already Link the database,How I get counts of the tables from the database
Thank You
Thank You
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Arvin Meyer
Stear said:I already Link the database,How I get counts of the tables from the database.
Thank You
Including the system tables, you can get a count like:
CurrentDB.TableDefs.Count
To get only the non-system tables (both linked and unlinked) try this query:
SELECT MSysObjects.Name, Left([Name],4)="MSys" AS Expr1, MSysObjects.Type
FROM MSysObjects
WHERE (((Left([Name],4)="MSys")=False) AND ((MSysObjects.Type)=1 Or
(MSysObjects.Type)=6));
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access