>I am not sure if this is connected or not but I am finding that I am unable to rename the data folder after the app has closed even though I have this cleanup code... I get a wondows error "Cannot rename data: There has been a sharing violation. The source or destination file may be in use" It like something is being left open...
>
>
>If Not DB Is Nothing Then
>If DB.State = adStateOpen Then
>DB.Close
>Set DB = Nothing
>End If
>End If
>
Ah this just happens when I run the project from the design window - if I run the exe it seems ok...