10000 and MaxRecords

[AlexeyU]

hi

I have a field with such rowsource:

Me!MYFIELD.RowSource = "exec MY_STORED_PROC 1"

My stored proc return about 60000 records (in query analyser)
but in ADP return only 10000.



MaxRecords=0
return 10000 records

MaxRecords= any other not 0 - 1, 10, 500, 20000, 10000000
return 10000 records

in stored proc:
set rowcount 0
return 10000 records

set rowcount 500000
return 10000 records

and only when i set rowcount to number smaller then 10000 it returns it
number of rows
set rowcount 20
return 20 records


How return all records?

thanks
-

 

[BJ Freeman]

That one got me also for a while

in the adp
Menu->tools->options
on the advance tab is the default max records.

 

[AlexeyU]

Big Thank you.


it help.

thank you

 

[msnews.microsoft.com]

555555555555555555555555555555555555

 

[msnews.microsoft.com]

dffffffffffffffffffffffffffffffffffff

 

[Andy Williams]

Check Tools...Options...

Advanced Tab: Default max records.

BTW, very descriptive subject line

-Andy

dffffffffffffffffffffffffffffffffffff