hibernate - When using Access from within an Excel spreadsheet, the PC won't go to sleep -

i've stumbled accross problem unable solve :( neither google nor stackoverflow have given me usable answers, i'm turning you.

the problem this: i've created spreadsheet loads data access database stored on network drive. data-loading part done once, i.e. when opening file.

i open connection this:

dim con adodb.connection dim rs new adodb.recordset dim sql string  set con = getconstring() rs.open "select id, somevalue sometable", con 

where connection string this

"provider=microsoft.jet.oledb.4.0;data source='" & (network path file) & "'" 

then dump information in spreadsheet , terminate connection this:

rs.close con.close 

however, when try hibernate pc while excel spreadsheet still open, error message. translates along lines of "excel has prevented computer going sleep".

this seems happen when using constellation... have idea on how prevent behavior? i'd pc go sleep, when tell - though excel spreadsheet still open.

thank :)

after close lines

set rs = nothing set con = nothing 

although cannot guarantee causing computer not hibernate - more information required.