>After having release the connections the VB6 program still
>prompt erro in connection being used exclusively.
>
>(1) connection to Access Database
>(2) rsStaff.Close
> Set rsStaff = Nothing
> cnn.Close
> Set cnn = Nothing
>(3) When Compact the DB, it prompt error of database already
> opened exclusively.
>
>Doesn't the (2) statement already free off the connection? Thanks.

Do you have bound controls? Reports?