Our customers occasionally get an error like this. Most of the time we find it is related to Anti-Virus or On-Demand backup tools causing the problem. Sometimes, but it's more rare, it's related to network (LAN) issues and the machine with the DBF is over taxed.
HTH, Tracy -----Original Message----- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Friday, July 31, 2020 5:43 PM To: profoxt...@leafe.com Subject: Re: VFP9SP2 Error 108: File is in use by another user. Yeah I stopped using DBFs in 2004!!!!! Took over Jeff Johnson's (RIP) client a few years back when he passed which is an all Fox backend. I added the SET TABLEVALIDATE TO 0. Will see if that helps. I don't have any RLOCKs or FLOCKs on this table. In this case, it's a simple logging table that only gets INSERT INTO commands to it. Never UPDATE or DELETE. Thanks for the lead, Frank!!! On 7/31/2020 4:11 PM, Frank Cazabon wrote: > I haven't used dbfs in years and can't say I've ever got this error but this > might help: > > https://www.tek-tips.com/viewthread.cfm?qid=686993 > > > On 31 July 2020 16:00:32 GMT-04:00, "MB Software Solutions, LLC" > <mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: >> Got a stupid 108 error on a simple INSERT INTO SQL today, yet no other >> application had that program/table open, and all usage is SHARED (set >> exclusive is OFF). >> >> Anybody else ever get an Error 108 on a simple INSERT where there's no >> exclusive use??? >> >> >> >> >> -- >> This email has been checked for viruses by Avast antivirus software. >> https://www.avast.com/antivirus >> >> >> _______________________________________________ >> Post Messages to: ProFox@leafe.com >> Subscription Maintenance: >> https://mail.leafe.com/mailman/listinfo/profox >> OT-free version of this list: >> https://mail.leafe.com/mailman/listinfo/profoxtech >> Searchable Archive: https://leafe.com/archives >> This message: >> https://leafe.com/archives/byMID/f933b99f-c4a3-c3ab-9184-a8d733c59...@mbsoftwaresolutions.com >> ** 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. >> >> Report [OT] Abuse: >> http://leafe.com/reportAbuse/f933b99f-c4a3-c3ab-9184-a8d733c59...@mbsoftwaresolutions.com [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/000c01d6678a$4d66aa50$e833fef0$@powerchurch.com ** 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.
