File is in use!!!

[Collin79]

Hi!!

I need help here, I'm testing a new form and I receive the message that File is in use, so I go to command window and do a Close databases and then I can continue. I've tried to assign this command on the form in the Init or load event but doesn't work.

Somebody may help me please!!

 

[foxdev]

You need to crank up the debugger and find which line is giving you the "File is in use" error, then tell us what the line of code is.
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[Collin79]

Hi Robert:

this is the line:

open database c:\sia1\dbf\main
Use c:\sia1\dbf\companies

 

[foxdev]

The most likely situation, then, is that companies is already open in another work area.

Here's a demonstration of how to cause the error:

[tt]close all
use MyTable
select 0 && different work area
use MyTable && error occurs [/tt]

The alternatives include:

* A *
if used("companies&quot
select companies
endif

* B *
use companies again alias comp2[/tt]

Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[Collin79]

Thanks Robert... it was so helpful

Collin79