Frank, Quick and dirty way.. Build two database view, one returning top 1000 using the qualification you want, and the other returning all.. and point these views to two AR System view forms.. each for each kind of group..
Joe ________________________________ From: Frank Caruso <[email protected]> To: [email protected] Sent: Wed, April 28, 2010 1:14:41 PM Subject: Limiting Queries ** Is there a way to limit the number records returned from user tool queries while at the same time allowing certain groups unlimited query capability? I want to limit all users form returning more than 1000 records but at the time allow certain groups unlimited capability. I know I can set a hard limit on the server but that would apply to everyone, including my nightly ODBC based reports, which return well over the 1000 record limit. I also know you can control this from the User tool but I cannot stop users from changing that value. Thoughts? Frank (18 days left in the desert!) _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

