How to count rows of Access data table?

I have one Access data base connected with my ASP.net site. When I want to fetch data it works fine.

I want to display total number of records of Access data table on my ASP.net page

That mean I have one label name lblTotalCount I want to set it’s Text property with total number of record count in Access Table so how can I do that?

Friends kindly help me.

Ajay

this simple query will return the total number of rows in a table

Code:

---

SELECT COUNT(*) FROM Table1

---

I haven't used Access in years and I can't remember if is supports the "*" operator.