General information
Category:
Coding, syntax & commands
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only