>>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?

No. Initial connection is for user to login, and checking of UserID
and Password only. Then, I will close all connection(mentioned about)
and start to Compact the database before actual main menu appear. Thanks.