Subject Re: In use by another
From Mervyn Bick <invalid@invalid.invalid>
Date Fri, 21 Mar 2025 10:49:37 +0200
Newsgroups dbase.getting-started

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.