Hello Ger

try putting a select 0, it's is't the best way but it's the one I know

select 0
use table1
select 0
use table2

"select 0" means select a unused data session


>Hi all,
>
>I have the following code
>
>IF !USED("mytable")
> USE c:\mydir\mytable.dbf ALIAS mytable
>ENDIF
>SELECT mytable
>GO TOP
>DO WHILE !EOF()
> IF !USED("mytable2")
> USE c:\mydir\mytable2.dbf ALIAS mytable2
> ENDIF
> REPLACE mytable.field1 WITH mytable2.field1
> SELECT mytable
> IF !EOF()
> SKIP
> ENDIF
>ENDDO
>
>But as soon as I open mytable2 the ALIAS mytable cannot be found.
>
>Why is this ?