Click here to Skip to main content
15,919,028 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how do i find total number of records of ACCESS table fastly other then count(*) method??????
Posted
Comments
MahaKh 6-Sep-12 2:10am    
ya it works but when i run this query in C# through my code the exception occures saying can read,do not have read permission to MSysObjects????

1 solution

VB
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
 
Share this answer
 
Comments
IdeasPravinh 5-Sep-12 5:01am    
PLease let me know if it works for u?
MahaKh 6-Sep-12 2:12am    
ya it works but when i run this query in C# through my code the exception occures saying can not read MSysObjects,do not have read permission to access MSysObjects????
IdeasPravinh 21-Sep-12 5:30am    
Give only read permission to MSysObjects.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900