MaxRecords on a stored proc?

[VBAHole22]

I have a stored procedure that I use to fill in a combobox on a user form. I like the fact that this box uses AutoExpand to finish off what the user is typing, however, I don't think that it is working with the entire range of possible values. When I run the proc in my Access project it defaults to 10,000 records. How can I bump this value up? I tried doing it with the slider on the bottom but that doesn't save it. And there are no properties for stored procs as far as I can see. Is there some way to put it right in the proc?

 

[BobJacksonNCI]

You might try changing the default max records.

Go to tools / options / advanced tab

On the right side is a box titled Client-server settings with the text below Default max records.

That most likely shows 10,000 - change it to whatever you require.

That MAY solve it for you. OR, there may be a limit on the SQL server itself...

Good Luck!
Bob

 

[VBAHole22]

That worked Bob. Seems strange that there would be an application-level setting for this as opposed to a property that was more specific to the actual stored proc. I looked all over the Books Online and didn't see anything.