Subject Re: In use by another From Tom <tom@railsoft.com> Date Fri, 21 Mar 2025 10:40:28 -0400 Newsgroups dbase.getting-started Mervyn Bick Wrote: > On 2025/03/20 18:14, Tom wrote: > > I have a client that uses a compiled program of mine.  Everything has worked well until they installed a new network program.  The program is not used by anyone except one person.  When she performs an indexing, she gets an error of "in use by another".  If she indexes again, no problem!  I have many others using this program with no problem, so I am sure it has something to do with the installed network program.  Any ideas? > > To be able to index a table dBASE requires exclusive use of the table. > > If your user can successfully create the indexes immediately after she > has acknowledged the error, place the code that does the indexing in a > try...catch...endtry construct.  Something like > > try >    use tablename exclusive >    reindex > catch(exception e) >    //repeat the code >   use tablename exclusive >   reindex > endtry > > Mervyn. > > Several others are using the exact same program on networks and are not having this problem!  All indexing is done in exclusive mode.