>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?
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com