>I have a file that is used throughout my application called 'EXTRACTFILES'. That is the filename and I am also using it as the alias name.
Jolene,

Open your table using this code;

IF USED("EXTRACTFILES")
   SELECT Extractfiles
ELSE
   USE Extractfiles ALIAS Extractfiles AGAIN
ENDIF

The AGAIN will prevent the file is in use error.