>>>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.
Aren't there any other user or apps in that database? How do you compact the database? I think you are using ADO, see this:
http://support.microsoft.com/support/kb/articles/Q230/5/01.ASP
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com