hey everyone,
here's my situation. i have a program that runs on a scheduler. the program runs fine, but i cannot access one of the databases the program inserts into if the program is still on the scheduler. i can acces the database if the program is not still on the scheduler. that is if the scheduler is not running. i am pretty sure the problem is that the database still thinks that it is being held in the work area. my problem is that i open 2 databases in the work area at once. the following code resembles the problem:

Use (example1.dbf) in 0 shared alias a_alias
Use (example2.dbf) in 0 shared alias a_alias2

select a_alias
scan

If a_alias->field > 0 .and. not empty(a_alias->field)

Insert into a_alias2 ;
( a , ;
b , ;
c )
Values (a_alias->x , ;
a_alias->y, ;
a_alias->z)

endif
endscan

does anyone have any suggestions on how to close both work areas when i am done.
i have a "use" command at the very end of the program but it doesn't seem to be closing this out. this statement is embedded in a nested if. any suggestions would be appreciated. thanks