>I do an OPEN DATABASE mydata in my program to allow access to the data off a network drive, but the problem is that my PATH is getting changed and now my program
>can not find my PUBLIC vars.
>

Are you perhaps doing a CLEAR ALL since your
public variables are being lost?