Yikes - what a muddle. I'll take a stab at it.
Assume the data is in VFP on a web server, running IIS, and IIS is using ASP with an ado connector to the vfp table. The iUsr account on the server machine doesn't have rights to the index file, as some one else reindexed the file , and the rights got mangled. If this query runs inside the asp code, I'd be worried, as it needs to make an intermediate file for the TOP 1 clause. Explain a wee bit more about the environment, please? I'm good at Triage, but without some more info, I feel like the handle on my oar was sheared off. -- William Sanders / efGroup _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.