Nick,

Perhaps you have some free tables that are not being closed. If that is the case, CLOSE DATABASES ALL should do the trick.

>I have the following code and when I execute it, I keep getting a message that "file is in use". Does anyone know what I am doing wrong? I am trying to wipe out my tables using command button.
>

>	case nAnswer2 = 6
>		close databases all
>		open database payroll exclusive
>		set safety off					
>		* use  && you shouldn't need this line...