IT might also be opportunistic locking causing a problem. Just for laughs, turn off opportunistic locking on that share.
--- On Tue, 9/30/08, Tracy Pearson <[EMAIL PROTECTED]> wrote: > From: Tracy Pearson <[EMAIL PROTECTED]> > Subject: RE: VFP9SP1 Error 1705 access denied when running INDEX on MyDateFld > tag MyDateFld > To: [email protected] > Date: Tuesday, September 30, 2008, 6:02 PM > Anti-Virus gets a lock. > > > > -----Original Message----- > From: MB Software Solutions General Account > Sent: Tuesday, September 30, 2008 6:13 PM > > We've got a client in the field who runs a report and > it creates an oddball > error, one that no one else is apparently getting....and > the best part---it > doesn't always happen, and it happens on multiple > machines if I heard her > right. It's legacy code from eons ago so it's not > like we just introduced a > bug recently with new code in that area of the program. > > The code is as follows, copied exactly as it is in the > source: > > > SELE *,000000.00 AS AmtUsed; > FROM TRANSACT; > WHERE inqnum = nInq; > AND Amount != 0; > INTO DBF (Temppath + "csrTrans.dbf") > > INDEX ON Transdate TAG Transdate > > > > The Temppath variable holds a LOCAL location that's > generated by the app > (e.g., > C:\Symplcty\SymPrefs\TempSym\_2GN0NJO2Z). > > I've checked the values in the Transdate column in that > table: 1 record > with a crazy date back in the year 0120, 2 records where it > was 0220, 1 from > 1901 and the rest appear to be normal. And these goofy > records aren't even > the ones in the query result. > > > If I were rewriting the code today, I'd change it to > use a local CURSOR > output, but apparently the original developers either > didn't have CURSORS > available to them or didn't understand how to use them > OR just preferred to > have local DBFs so they could check data as they debugged > from other Fox > windows. (I knew a legacy guy who practiced the > latter...may he RIP.) > > Can anyone give a reason as to why the INDEX ON Transdate > TAG Transdate line > would throw an Error 1705 File access is denied on the CDX > file? > It's worthy of noting too that my colleague and I went > to the folder to see > the files, and the DBF and FPT were there, but NO CDX was > present. > > WEIRD!!! > > Any advice appreciated...thanks!!!! > --Michael > > > > > _______________________________________________ > Post Messages to: [email protected] > 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. _______________________________________________ Post Messages to: [email protected] 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.
