how can i get the count of table records in ASP?

I used the movelast and movefirst and recordcount but it generates an Error:
Technical Information (for support personnel)
Error Type:
Microsoft JET Database Engine (0x80040E24)
Rowset does not support fetching backward.

Jeff
Sun Apr 24 08:56:37 CDT 2005

Care to give the actual script so the experts can see it??
Jeff




"Ahmed" <Ahmed@discussions.microsoft.com> wrote in message
news:CE4F56ED-44CD-410F-A2C5-5C8025CF6C6F@microsoft.com...
>I used the movelast and movefirst and recordcount but it generates an
>Error:
> Technical Information (for support personnel)
> Error Type:
> Microsoft JET Database Engine (0x80040E24)
> Rowset does not support fetching backward.
>

MikeR
Sun Apr 24 11:20:13 CDT 2005

Ahmed -
Most likely caused by opening the database with the default cursor. Take
a look at this link.
http://psacake.com/web/et.asp
HTH
MikeR

Ahmed wrote:
> I used the movelast and movefirst and recordcount but it generates an Error:
> Technical Information (for support personnel)
> Error Type:
> Microsoft JET Database Engine (0x80040E24)
> Rowset does not support fetching backward.
>

clintonG
Sun Apr 24 17:22:07 CDT 2005

You need to know about and use the ASP FAQ [1]
The ASP FAQ supports ASP error message search.


<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/

[1] http://www.aspfaq.com/



"Ahmed" <Ahmed@discussions.microsoft.com> wrote in message
news:CE4F56ED-44CD-410F-A2C5-5C8025CF6C6F@microsoft.com...
>I used the movelast and movefirst and recordcount but it generates an
>Error:
> Technical Information (for support personnel)
> Error Type:
> Microsoft JET Database Engine (0x80040E24)
> Rowset does not support fetching backward.
>

Mohammed
Mon Apr 25 04:01:01 CDT 2005

See this website
1) http://www.asp101.com/samples/db_count.asp?showtable=true
2) http://www.asp101.com/samples/viewasp.asp?file=db%5Fcount%2Easp

"clintonG" wrote:

> You need to know about and use the ASP FAQ [1]
> The ASP FAQ supports ASP error message search.
>
>
> <%= Clinton Gallagher
> METROmilwaukee (sm) "A Regional Information Service"
> NET csgallagher AT metromilwaukee.com
> URL http://metromilwaukee.com/
> URL http://clintongallagher.metromilwaukee.com/
>
> [1] http://www.aspfaq.com/
>
>
>
> "Ahmed" <Ahmed@discussions.microsoft.com> wrote in message
> news:CE4F56ED-44CD-410F-A2C5-5C8025CF6C6F@microsoft.com...
> >I used the movelast and movefirst and recordcount but it generates an
> >Error:
> > Technical Information (for support personnel)
> > Error Type:
> > Microsoft JET Database Engine (0x80040E24)
> > Rowset does not support fetching backward.
> >
>
>
>